Running an Add-In on the fly

[Kigol]

It seems I have found every answer on how to run an add-in except how
to run it as a macro on command. I have the add-in installed and can
see the code in the VBE but there are no macros listed in the macro
list. I do not want it to autorun everytime I open excel, I want to
be able to choose when I can run it. Just avoiding the hassle of
installing macro code to a new workbook every time I want to run it.
What's the down low because it is pretty annoying? Thanks.

 

[Ron de Bruin]

Create a menu for your add-in
You not see macros in the Alt F8 list from a Add-in

See Dave's example
http://www.contextures.com/xlToolbar02.html

 

[Kigol]

I'm working on a procedure to create my menubar add-in using a hybrid
of Dave's example and what I found on j-walk.com. Hopefully I get the
results I desire. Is it possible to have a my menu refer to macros
outside of the workbook and add-in? Does this involve using dll's or
can I just write a static path? Thank you very much for your speedy
response Ron.

 

[Jon Peltier]

Kigol -

When you assign the macro in the code, indicate the file name:

.OnAction = "'" & someworkbook.name & "'!" & macroname

I'm not sure what to do with a closed workbook, you need the path as well,
but I'm not sure of the format. Something like this:

.OnAction = "'C:\My Folder\My Workbook.xls'!MyMacro"

- Jon