Hi All,

I am trying to assign a custom macro to a custom command button I have
inserted into my menu bar. When I click on assign macro, there is no
listing of my custom macros I have created in VBA (custom .xla file). So I
type the macro name in. (Main.myMacro)

When I click on the button it says "book1.xls'Main.myMacro" does not exist.

of course not it is in myAddin.xla.

So I change it to myAddin.xla'Main.myMacro and it says it cannot open this
file because it is already open.

I have an old button that works with just Main.MyotherMacro. But if I type
Main.MyMacro it automatically changes it to "book1.xls'Main.myMacro" once I
close it.

I cannot remember how I got the other to work.

Please Help
Chad