Excel tip: What is an Add In?Date: 5 september 2001
What is an Add In?An Add In is a workbook with custom commands and functions that can be used with Excel. Add In's are used to distribute macros, userdefined functions or custom solutions to other users.
When you save a workbook as an Add In, the content is "compiled" and protected so that the source code is (usually) not visible and editable by other people. You can find tools on the Internet that can "crack" this protection from Add In's made for Excel 5/95 and Excel97, but ordinary users will usually not be able to see or edit the contents of an Add In.
Add In's can be installed by opening the file as you open an ordinary workbook. You can also install the Add In by saving it to the Library folder and installing it from the Add In Manager with the menuchoice Tools | Add Ins.... When you install an Add In the custom functions are available to the user, and any userdefined menus in the Add In will also be added to the existing menus in Excel.
Add In's installed by the Add In Manager can be uninstalled by removing the checkmark in the list of installed Add In's in the Add In Manager.
Add In's can also be installed and uninstalled by using VBA-code
How secure is the Add In source code?The source code in an Add In is poorly protected against users that are determined to take a look at it. There are both (almost) free tools and commercial tools available that can "decompile" the Add Ins (for all Office-applications). If you need one you only have to search the Internet. Maybe the source code protection is more reliable in the COM Add-Ins used by Office 2000?
How to create an Add In in Excel97Add Ins in Excel97 are saved differently from the previous versions of Excel:
You can convert a workbook to an Add In by changing the property IsAdd In to True for the ThisWorkbook-object. This must be done from the Visual Basic Editor. When the property is changed you can save the workbook by clicking on the Save-toolbarbutton.
Setting a Password for Your ProjectTo ensure that a user doesnít inadvertently or purposely change any of the code in an add-in that youíve created, itís a good idea to protect the add-in by assigning a password to the Visual Basic for Applications project associated with it.
Share this page:
List of all utilities
Printer friendly page
^ Back to Top