Microsoft Office Tutorials and References
In Depth Information
Installing an Add-In
A quick way to open the Add-Ins dialog box from any version of Excel is to press
the Alt+TI keys — that is, hold down the Alt key and with your other hand press
the T key and the I key. If you prefer to work with a mouse instead of the keyboard,
and you prefer not to show the Developer tab, you can access the Add-Ins dialog
box another way. In Excel version 2007, click the Office button, then click the
Excel Options button. In Excel version 2010, click the File tab, click the Options
menu item, and select the Add-Ins menu item. At the bottom of the window, select
Excel Add-Ins from the Manage drop-down list, and click the Go button.
To include an add-in on the Add-Ins list, click the Browse button on the Add-Ins dialog box.
Navigate to the folder where you saved the add-in file, select the filename, and click OK to exit the
Browse dialog box as indicated in Figure 22-11.
You now will see your selected file listed in the Add-Ins dialog box. By default, Excel places a
checkmark next to the selected add-in’s name. If you don’t want the add-in to be open — that is, for its
features to be available to you — simply deselect the add-in by unchecking the box next to its name.
If and when you do select your new add-in, you and the users of that add-in will appreciate the extra
time you spent in the Properties window before you converted the original file to an add-in. Notice
that the selected add-in’s filename and comments appear at the bottom of the Add-Ins dialog box,
informing the user what the add-in does. In any case, now that you’ve listed the add-in file, click the
OK button to exit the Add-Ins dialog box as indicated in Figure 22-12.