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

Aha - I was missing the obvious that although the macro wasn't available to
select from the drop-down list, you can still load it by typing the name in.

Thanks Gary and Tom.

Andi


"Gary Brown" wrote in message
...
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