C
CLS
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
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