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

Set the IsAddin property of your addin to False, assign the macro
to the command button, and the set the IsAddin property to True.
To set the property, go to the VBA editor, open the Immediate
Window (CTRL+G) and enter

ThisWorkbook.IsAddin = False ' then True to restore


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com








"CLS" remove NOT wrote in message
...
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

Worked Great
Thanks

"Chip Pearson" wrote in message
...
Set the IsAddin property of your addin to False, assign the macro to the
command button, and the set the IsAddin property to True. To set the
property, go to the VBA editor, open the Immediate Window (CTRL+G) and
enter

ThisWorkbook.IsAddin = False ' then True to restore


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com








"CLS" remove NOT wrote in message
...
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