Activating macro with a Toolbar

JeffSavoie · Apr 22nd, 2002, 08:10 AM

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 !

JeffSavoie · Apr 22nd, 2002, 08:23 AM

I really need help with this one. I can't find anything in books...

klb · Apr 22nd, 2002, 08:26 AM

Why can't you just assign the macro from main.xla to the button without referencing setup.xla?

JeffSavoie · Apr 22nd, 2002, 08:31 AM

Quote:

On 2002-04-22 07:26, klb wrote:
Why can't you just assign the macro from main.xla to the button without referencing setup.xla?

It would long to explain, but i cannot...

I try to figure if there is a way to do it like that because i need it to work like that. I hope there is a solution !

JeffSavoie · Apr 22nd, 2002, 09:52 AM

No one has another idea ?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 22nd, 2002, 08:10 AM	#1
JeffSavoie New Member Join Date: Apr 2002 Posts: 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 !

Apr 22nd, 2002, 08:23 AM	#2
JeffSavoie New Member Join Date: Apr 2002 Posts: 7	I really need help with this one. I can't find anything in books...

Apr 22nd, 2002, 08:26 AM	#3
klb Board Regular Join Date: Apr 2002 Location: Minnesota Posts: 821	Why can't you just assign the macro from main.xla to the button without referencing setup.xla?

Apr 22nd, 2002, 09:52 AM	#5
JeffSavoie New Member Join Date: Apr 2002 Posts: 7	No one has another idea ?