Microsoft Office Tutorials and References
In Depth Information
5. In the Save As dialog box, select Excel Add-In (*.xlam) from the Save as Type drop-down
6. If you don’t want to store the add-in in the default directory, select a different directory.
7. Click Save.
A copy of the workbook is saved (with an .xlam extension), and the original
macroenabled workbook ( .xlsm ) remains open.
When you use functions that are stored in an add-in, Excel creates a link to that add-in
file. Therefore, if you distribute your workbook to someone else, they must also have a
copy of the linked add-in. Furthermore, the add-in must be stored in the exact same
directory because the links are stored with complete path references. As a result, the
recipient of your workbook may need to use the Data
command to change the source of the linked add-in.
After you create your add-in, you can install it by using the standard procedure:
1. Choose File
Options, and click the Add-Ins tab.
2. Select Excel Add-ins from the Manage drop-down list.
3. Click Go. This will show the Add-Ins dialog box.
4. Click the Browse button in the Add-Ins dialog box.
5. Locate your *.xlam file.
A much quicker way to display the Add-Ins dialog box is to press Alt+TI.
A few words about passwords
Microsoft has never promoted Excel as a product that creates applications with secure source
code. The password feature provided in Excel is sufficient to prevent casual users from
accessing parts of your application that you want to keep hidden. However, the truth is that several
password-cracking utilities are available. The security features in Excel 2002 and later are much
better than those in previous versions, but it’s possible that these can also be cracked. If you
must be absolutely sure that no one ever sees your code or formulas, Excel is not your best
choice as a development platform.