Using Custom Add-Ins

Summary: Add-ins are special Excel programs that enable features or capabilities not in the original program. Once you've created your own custom add-in, you need to enable it in Excel; this tip explains how. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

After you have created your own add-in, you can use it in your system. Once the add-in has been loaded, the functions or features in the add-in become available to any other workbook you may have open, or any time you are using Excel. All you need to do to use your add-in is follow these steps:

Choose Add-Ins from the Tools menu. This displays the Add-Ins dialog box. (Click here to see a related figure.)
If your custom add-in is visible in the dialog box, click the check box beside it and skip to step 6.
Click on the Browse button. Excel displays a standard file dialog box.
Use the controls in the dialog box to locate and select your custom add-in.
Click on OK. The add-in is loaded and made a part of Excel. (You can tell that the add-in is available because it is now listed in the Add-Ins dialog box.)
Click on OK to close the Add-Ins dialog box.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2277) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Tame Your Data! ExcelTips: Filters and Filtering provides all the details necessary to let you manage large sets of data with confidence and ease. Its information-packed pages demonstrate how to use the two types of filters provided by Excel: AutoFilters and advanced filters.

Check out ExcelTips: Filters and Filtering today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Using Custom Add-Ins