Loading
Excel.Tips.Net ExcelTips (Menu Interface)

Using Custom Add-Ins

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.

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. (See Figure 1.)
  2. Figure 1. The Add-Ins dialog box.

  3. If your custom add-in is visible in the dialog box, click the check box beside it and skip to step 6.
  4. Click on the Browse button. Excel displays a standard file dialog box.
  5. Use the controls in the dialog box to locate and select your custom add-in.
  6. 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.)
  7. 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.

Related Tips:

Excel Smarts for Beginners! Featuring the friendly and trusted For Dummies style, this popular guide shows beginners how to get up and running with Excel while also helping more experienced users get comfortable with the newest features. Check out Excel 2013 For Dummies today!

 

Leave your own comment:

*Name:
Email:
  Notify me about new comments ONLY FOR THIS TIP
Notify me about new comments ANYWHERE ON THIS SITE
Hide my email address
*Text:
*What is 5+3 (To prevent automated submissions and spam.)
 
 
           Commenting Terms

Comments for this tip:

Willy Vanhaelen    04 Nov 2015, 10:37
@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):

Private Sub Workbook_Open()
   Application.OnKey "^+a", "ShowAll" 'Shift+Ctrl+A
End Sub

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
Lucilla    03 Nov 2015, 12:13
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.

Thanks a lot for any support you can give to me!

Best regards
Lucilla
 
 

Our Company

Sharon Parq Associates, Inc.

About Tips.Net

Contact Us

 

Advertise with Us

Our Privacy Policy

Our Sites

Tips.Net

Beauty and Style

Cars

Cleaning

Cooking

DriveTips (Google Drive)

ExcelTips (Excel 97–2003)

ExcelTips (Excel 2007–2016)

Gardening

Health

Home Improvement

Money and Finances

Organizing

Pests and Bugs

Pets and Animals

WindowsTips (Microsoft Windows)

WordTips (Word 97–2003)

WordTips (Word 2007–2016)

Our Products

Helpful E-books

Newsletter Archives

 

Excel Products

Word Products

Our Authors

Author Index

Write for Tips.Net

Copyright © 2016 Sharon Parq Associates, Inc.