Part VI: Automating Excel
As previously noted, Excel ships with several useful add-ins, and you can acquire other
add-ins from third-party vendors or online. In addition, Excel includes the tools that enable
you to create your own add-ins. We explain this process later in this chapter (see “Creating
Add-Ins”).Working with Add-Ins
The best way to work with add-ins is to use the Excel Add-In Manager. To display the
Add-In Manager, follow these steps:- Choose File ➪ Options. The Excel Options dialog box appears.
- Select the Add-Ins category.
- At the bottom of the dialog box, select Excel Add-Ins from the Manage list and
then click Go.
The Add-Ins dialog box appears, as shown in Figure 48.1. The dialog box contains all the
add-ins that Excel knows about, which varies from computer to computer. The add-ins that
are checked are open. You can open and close add-ins from this dialog box by selecting or
deselecting the check boxes.
FIGURE 48.1
The Add-Ins dialog box