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

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/...oadcommandbars

How to customize menus and menu bars in Excel
http://support.microsoft.com/default...02&Product=xlw




--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"DougW" wrote in message ...
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?
--
DougW