Using Custom Add-Ins

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:

1. Choose Add-Ins from the Tools menu. This displays the Add-Ins dialog box. (Click here to see a related figure.)
2. If your custom add-in is visible in the dialog box, click the check box beside it and skip to step 6.
3. Click on the Browse button. Excel displays a standard file dialog box.
4. Use the controls in the dialog box to locate and select your custom add-in.
5. 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.)
6. Click on OK to close the Add-Ins dialog box.