Activating macro with a Toolbar

[JeffSavoie]

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]

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

 

[klb]

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

 

[JeffSavoie]

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]

No one has another idea ?