Microsoft Office Tutorials and References
In Depth Information
When you exit Excel, the current toolbar configuration is saved in a file named Excel12.xlb .
This file is (most likely) located here:
This binary file contains information regarding the position and visibility of all custom toolbars
and custom menu bars, plus modifications that you’ve made to built-in toolbars or menu bars.
An add-in is essentially an Excel workbook file with a few important differences:
h The workbook’s IsAddin property is True — which means that it can be loaded and
unloaded by using the Add-Ins dialog box.
h The workbook is hidden and cannot be unhidden by the user. Consequently, an add-in is
never the active workbook.
h When using VBA, the add-in workbook is not part of the Workbooks collection.
Access the Add-Ins dialog box by choosing File➜Excel Options. Click the Add-Ins tab,
select Excel Add-Ins from the Manage list, and click Go. If you’ve set up Excel to display
the Developer tab, you can also use Developer➜Add-Ins➜Addins. Or (easiest of all),
just press Alt+TI, a handy key combination leftover from Excel 2003.
Many add-ins provide new features or functions to Excel. You can access these new features as if
they were built into the product.
You can create your own add-ins from workbook files. In fact, creating add-ins is the preferred
method of distributing some types of Excel applications. Excel 2010 add-ins have an XLAM
extension by default.
Besides XLAM add-ins, Excel supports XLL add-ins and COM add-ins. These types
of add-ins are created using software other than Excel. This topic discusses only XLAM
Chapter 21 covers the topic of add-ins in detail.