You can get Excel add-ins from a number of places:
Excel includes several add-ins that you can use whenever you need them. Use the Add-Ins dialog box to install them.
You can download more add-ins from the Microsoft Office Update Web site.
Third-party developers distribute and sell add-ins for special purposes.
Many developers create free add-ins and distribute them via their Internet sites.
You can create your own add-ins.
The most common way to install an add-in is by using the Add-Ins dialog box. Choose Office Excel Options. In the Excel Options dialog box, select the Add-Ins tab. Then, select Excel Add-ins from the Manage drop-down control and click Go. A quicker method to display the dialog box is to press Alt+TI.
You can also install an add-in by using the Office
Before creating the add-in, use the Office Prepare Properties command to display the Properties panel. In the Title field, enter the text that you want to appear in the Add-Ins dialog box. In the Comments field, enter the description for the add-in. Then create the add-in as usual.
Oddly, there is no way to remove unwanted add-ins from the list directly from Excel. One way to remove an add-in from the list is to move or delete the add-in file. Then, when you attempt to open the add-in from the Add-Ins dialog box, Excel will ask whether you want to remove the add-in from the list. Answer yes.
Activate any worksheet and then choose Office Save As. Then select Excel Add-in (*.xlam) from the Save as Type drop-down list. The add-in is created, and the original workbook remains open.
The most likely reason is that the active sheet is not a worksheet.
No! Although you
create an add-in from any workbook, not all workbooks are suitable. When a workbook is converted to an add-in, it is
No, you can edit an add-in and even convert an add-in back to a normal workbook.
If you need to modify only the VBA code, no special action is required; you can access the code from the VBE and then save your changes in the VBE. If you need to modify information on a worksheet, activate the VBE (press Alt+F11) and then set the IsAddIn property of the ThisWorkbook object to False . Make your changes to the worksheet, set the IsAddIn property to True , and resave the file.
There isn't a great deal of difference between the files, and you
Activate the VBE and choose Tools xxxx Properties (where xxxx is the name of your project). Click the Protection tab, select Lock Project for Viewing, and enter a password. Then save the file.
Protect your add-in by locking it with a password. This