Tool Bars

[Mordred]

This is a cross post, here is the link

I thought the problem was fixed but I just received a complaint from a coworker in my department. I'll restate the problem.

Lets say I have a workbook, call it "W1", where I have attached a custom toolbar and button. And, lets say that the "W1" in a shared drive within my department. The problem is, when someone opens a different workbook, call it "W2", the toolbar that I attached to "W1" is active on "W2"-where it shouldn't be. I've told my coworker to right click the toolbar and deselect it, which he did. But, isn't there a way to have the toolbar active on just "W1"?

[royUK]

Create the ToolBar using VBA


Add_Toolbar.zip

[Paul]

Hi Mordred,

You would need to add code to the workbook_activate and workbook_deactivate modules in the workbook where you want to hide/see the custom toolbar. Here's a link to a page that explains the process, hopefully it helps you out: http://www.ozgrid.com/VBA/toolbar-remove-restore.htm

[Mordred]

Thanks, I'll try this again.

[Mordred]

Thank you for the link Paul, I tweeked the code a little but it finally works properly. You guys are the best.