View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Call Macro in Add-in

Just type in (for example)

MyAddin.xls!MyMacro

in the dialog. Change to reflect your addin name and the actual macro
name. (hey, some people take these things literally).

Make sure your addin in loaded.



--
Regards,
Tom Ogilvy


"Andibevan" wrote in message
...
Hi All,

I am sure this is a really easy one but I can't work it out.

How do I call a macro that is stored in an add-in I created. I want to
assign it to a button on the toolbar but when I try to assign a macro to

the
button the macro is not availble

Ta

Andi