Using Add-ins

[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?

 

[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