View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Brown[_5_] Gary Brown[_5_] is offline
external usenet poster
 
Posts: 236
Default Call Macro in Add-in

Assume the Add-in is called MyAddin.xla and the macro is called MyMacro...
MyAddin.xla!MyMacro
should do it although I like to use...
Call MyAddin.xla!MyMacro
because it identifies it as a macro when I'm reviewing old code. Works
either way.
HTH,
--
Gary Brown



"Andibevan" wrote:

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