Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: Understanding Add-Ins.
Many features of Excel are available only through what are called add-ins. For instance, the Analysis ToolPak is a good example of an add-in. The tools available in add-ins such as the Analysis ToolPak are not part of the basic Excel system, but can be added to the system as needs dictate. These add-ins are nothing more than programs which have been "added to" Excel in such a way that they appear to be part of Excel itself.
You also know that macros are nothing more than programs that you write using a language understood by Excel. These programs instruct Excel to perform tasks that otherwise might be time consuming or repetitious on your part. These programs, if elaborate enough, can become full-fledged applications that operate under Excel.
Excel allows you to translate your macro programs into add-ins, which can become part of Excel—the same as the Analysis ToolPak and others. Eventually you might want to take advantage of this capability. The files you convert to add-ins do not need to be elaborate, nor do they have to be fancy. Converting them to add-ins does have several advantages, however:
In essence, add-ins are nothing but a special type of workbook which you have converted to an add-in format that is understood by Excel.
You may want to make sure your macro code which is destined to be an add-in performs some initializing routine that modifies, in some way, the Excel user interface. For instance, most add-ins modify the menu structure in some way so that the functions in the add-in can be accessed. Your macros should take care of the menu modification so that people can access your add-ins. If you don't modify the interface in some way, then users can only get to the macro code in your add-in by directly referencing in a worksheet formula the names of any functions in your add-in.
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2276) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Understanding Add-Ins.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
Add-ins are used to extend Excel's capabilities in lots of different ways. If you want to get rid of an add-in ...
Discover MoreOnce you've created your custom add-in, you need to know how you or other people can use it. Here are the simple steps to ...
Discover MoreWant to load a particular add-in for use with a specific worksheet? Here's a quick way to do it using macros.
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
2016-03-21 13:01:01
It would be nice if this tip included steps on how to translate macro programs into add-ins, or a link to these steps. I could not find anything on the internet on how to do this.
2014-06-22 04:33:02
Dave Beecham
But how do you convert the macro to an add-in?
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2020 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: 
Comments