Create An Excel VBA Add In

If you have created VBA code and want the sub procedures and functions to be available in all existing and future workbooks you create, then the best way to access your VBA code is to create an Excel Add In. An add in for all intent and purpose, is a regular Excel Workbook with VBA which has a .xlam (or .xla in Excel 2003 or earlier) file extension. Once saved and installed as an Add In, the workbook is automatically opened and hidden so the VBA procedures and functions are accessible to all other workbooks. The Add In is hidden in a special way so that it can only be seen from the Project Explorer in the Visual Basic Editor (VBE) and can not be unhidden from within Excel. Add Ins are an ideal way of distributing VBA code. Excel comes with Add Ins that are not installed by default like Analysis ToolPak, Solver etc.

The full article appears here:
http://www.microsofttraining.net/article-625-create-excel-vba-add-in.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com