Using Add-ins

D

DougW

I have written a small VB program to revise spreadsheets (remove columns,
rows, etc) and it runs fine when tested on the spreadsheet where I created
it.

I have saved it as an add-in file, and it is listed in Excel as one of the
available add-ins (box is checked on the Add-Ins dialog box).

My question is:

How do I actually run the add-in? If I open a new file, the add-in is there,
but how do I "invoke" it to run after I open the new file?
 
R

Ron de Bruin

Hi Doug

You must create a menu to run your code in the add-in
See the examples below for

If you use 2007 post back

Excel 97-2003

Debra Dalgleish's (Toolbar example from Dave Peterson)
http://www.contextures.com/xlToolbar02.html

Creating Custom Menus (John Walkenbach)
http://www.j-walk.com/ss/excel/tips/tip53.htm

Ole P. Erlandsen's Web Site (Example workbooks)
http://www.erlandsendata.no/english/index.php?d=endownloadcommandbars

How to customize menus and menu bars in Excel
http://support.microsoft.com/default.aspx?scid=kb;en-us;830502&Product=xlw
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top