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.

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


--

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


"Kigol" wrote in message oups.com...
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.

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.


On Jun 13, 2:57 pm, "Ron de Bruin" wrote:
Create a menu for your add-in
You not see macros in the Alt F8 list from a Add-in

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

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Kigol" wrote in ooglegroups.com...
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.- Hide quoted text -

- Show quoted

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Kigol" wrote in message
oups.com...
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.


On Jun 13, 2:57 pm, "Ron de Bruin" wrote:
Create a menu for your add-in
You not see macros in the Alt F8 list from a Add-in

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

--

Regards Ron de Bruinhttp://www.rondebruin.nl/tips.htm



"Kigol" wrote in
ooglegroups.com...
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.- Hide quoted
text -

- Show quoted