Working with Add Ins

The most efficient way to load and unload add-ins is by choosing ToolsO Add-Ins. This command displays the Add-Ins dialog box shown in Figure 22-1. The list box contains the names of all add-ins that Excel knows about. In this list, check marks identify any currently open add-ins. You can open and close add-ins from the Add-Ins dialog box by selecting or deselecting the check boxes.

Figure 22-1:

The Add-Ins dialog box lists all of the add-ins known to Excel.

Add-Ins available:

Analysis ToolPak

A

Analysis ToolPak - VBA

Book2

Conditional Sum Wizard

Euro Currency Tools

Extended Date Functions

Google Search 5.0

Gradient Contour Chart

5

Internet Assistant VBA

Lookup Wizard

My Functions

Power Utility Pak v5

Sample Add-In

Solver Add-in

Sound-Proof 2000

Text Tools Utility

0

Provides functions and interfaces for financial and scientific data analysis

Provides functions and interfaces for financial and scientific data analysis

JUNG/

Figure 22-1:

The Add-Ins dialog box lists all of the add-ins known to Excel.

JUNG/

You can open most add-in files also by choosing the FileOOpen command. However, you can't close an open add-in by choosing FileOClose. You can remove the add-in only by exiting and restarting Excel or by writing a macro to close the add-in.

When you open an add-in, you may or may not notice anything different. In many cases, however, the menu changes in some way — Excel displays either a new menu or one or more new items on an existing menu. For example, when opening the Analysis ToolPak add-in gives you a new menu item on the Tools menu: Data Analysis. If the add-in contains only custom worksheet functions, the new functions appears in the Insert Function dialog box.

0 0

Post a comment