Using An Add-In

 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. To use your add-in, choose ‘Add-Ins’ from the ‘Tools’ menu. This displays the ‘Add-Ins’ dialog box. If your custom add-in is visible in the dialog box, click the checkbox beside it and click ‘OK’—you’re done. Otherwise, click ‘Browse’, and use the controls in the dialog box to locate and select your custom add-in.