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: Using Custom Add-Ins.

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:

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 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: Using Custom Add-Ins.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. Learn more about Allen...

MORE FROM ALLEN

AutoFilling with Weekdays

Need to fill a range of cells with the days of the week? Excel makes it easy to do so using AutoFill.

Save Time and Supercharge Excel! Automate virtually any routine task and save yourself hours, days, maybe even weeks. Then, learn how to make Excel do things you thought were simply impossible! Mastering advanced Excel macros has never been easier. Check out Excel 2010 VBA and Macros today!

More ExcelTips (menu)

Excluding a Specific Add-In at Startup

Got an add-in that you don't want loaded each time that Excel starts up? Here's a few ways that you can exclude it.

Comments

If you would like to add an image to
your comment (not an avatar, but an image to help in making the point of your comment),
include the characters [{fig}] in your comment text. You’ll be prompted to upload
your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will
be reduced. Up to three images may be included in a comment. All images are subject to
review. Commenting privileges may be curtailed if inappropriate images are posted.

Source

(gif, jpeg or png only, 5MB maximum file size)

Source

(gif, jpeg or png only, 5MB maximum file size)

Source

(gif, jpeg or png only, 5MB maximum file size)

Notify me about new comments ONLY FOR THIS TIP

Notify me about new comments ANYWHERE ON THIS SITE

Hide my email address

What is six more than 8?

2015-11-04 10:37:57

Willy Vanhaelen

@Lucilla

You can't run an add-in. It loads automatically every time you run Excel. You can access it in the VB editor and insert macros in a module. However those macros are not visible in the Run macro dialog box but they can be assigned to a button in the QAT or you can assign a shortcut key to them via the OnKey method like this (insert it in the add-inn's 'ThisWorkbook' code sheet):

You can also run an add-in's macro from a custom command in the ribbon. For more info on this, see my website at: http://wv-be.com/Ribbon.asp

2015-11-03 12:13:12

Lucilla

Hi,Thanks a lot for your tips! I am quite new with Add-Ins but also quite good with Macros. I have a macro that, with some files as input produce me a power point with graphs and tables. Now, I would like to create an Add-In from this macro. I saved the file as .xlam and I have added the Add-In on my excel... now??? how can I run the add-in? I cannot find it anywhere! I see it in the list of add-ins from the "option" menu, but from the workbook I cannot call it. I am using excel 2007.