Attaching menus creating problems 1

[Dan15]

Here is the situation: A custom menu bar is created on one computer, then the excel template is put on the server. When the template is put on a different computer, the menu items on the custom menu are not working. This is because they are looking at the original template for the code to execute the macros, even though the macros are copied in the template. I would rather not go to each menu item and re-address the macro location, what is the way to go about fixing this?

Thanks-

-Dan

 

[RobBroekhuis]

Even though I have no access to XP, I can suggest a start to troubleshooting this:

In the immediate window in VBE, type

?typename(application.commandbars(strtoolbar))
and
?typename(application.commandbars(strtoolbar).controls(1))

and report back the results. Also, you might want to try to

dim oC As Object

instead of a CommandBarControl, and see how that goes.
Rob

 

[RobBroekhuis]

I just noticed Dan started a new thread for this. Good idea - I'll repost above in the new thread.
Rob