JeffSavoie
New Member
- Joined
- Apr 10, 2002
- Messages
- 7
I have two XLA containing macro (setup.xla and main.xla).
I have a toolbar with button that should start macro.
I want to set the button with a macro from SETUP.XLA to start macro from MAIN.XLA.
My line in SETUP.XLA, to set the button, is :
Toolbars(sTBName).ToolbarButtons(TB_POSOPENTOOL).OnAction = StartProgram
--> [StartProgram] is a macro in the MAIN.XLA file
The problem i get is when i clic on the button Excel is looking for the macro [StartProgram] in SETUP.XLA and can't find it (because it's in MAIN.XLA).
Is there any way to specify that the macro to start onAction is located in the MAIN.XLA and not in SETUP.XLA ?
Thanks !
I have a toolbar with button that should start macro.
I want to set the button with a macro from SETUP.XLA to start macro from MAIN.XLA.
My line in SETUP.XLA, to set the button, is :
Toolbars(sTBName).ToolbarButtons(TB_POSOPENTOOL).OnAction = StartProgram
--> [StartProgram] is a macro in the MAIN.XLA file
The problem i get is when i clic on the button Excel is looking for the macro [StartProgram] in SETUP.XLA and can't find it (because it's in MAIN.XLA).
Is there any way to specify that the macro to start onAction is located in the MAIN.XLA and not in SETUP.XLA ?
Thanks !