Microsoft Office Tutorials and References
In Depth Information
Installing an Add-In
While saving a file as an add-in, you must have a worksheet be the active sheet.
If by chance you have a chart sheet in your file and it is the active sheet, the Save
As Type drop-down list won’t include an Add-in file type.
insTAlling An Add-in
If your add-in is being distributed to other users,
the first thing you do is to deliver the add-in file to
them in some way, such as by e-mail, or on a Flash
drive if by hand delivery. In any case, your users
would save the add-in file to whatever folder they
prefer, similar to how you saved your add-in file
into a folder on your computer.
The easiest way to install an add-in is to use the
Add-Ins dialog box, which you can do from any
open workbook. In versions of Excel prior to 2007,
from the worksheet menu click Tools ➪ Add-Ins
as shown in Figure 22-8. In versions 2007 and
2010, click the Developer tab on the Ribbon, and
select the Add-Ins icon as shown in Figure 22-9.
An example of the Add-Ins dialog box is shown
in Figure 22-10.
The Add-Ins dialog box shows a list of all the add-ins that Excel is
aware of. An add-in is open if a checkmark is next to its name in the
list. You’ll notice in Figure 22-10 that no add-ins are selected, and
that the SheetManager add-in is not listed in the Add-Ins dialog box.
When a new add-in is created, it does not automatically appear in the
Add-Ins dialog box. To install a new add-in, you first need to list it
in the Add-Ins dialog box, and then select it in the list.
The Developer tab is a very useful item to place on your Ribbon. See the section
named “Accessing the VBA Environment” in Lesson 2 for the steps to display
the Developer tab.