[RESOLVED] [EXCEL] Buttons in the toolbar

[studmanjake]

I have now created a toolbar with the buttons in that, and I attach it to that workbook like it says in the help menu. When someone else opens it, the toolbar appears. But it also appears on all other excel workbooks. You can go and take off the toolbar, but than it is taken off the workbook I want. Is there a way to attach the toolbar JUST to one workbook?

[studmanjake]

I figured it out. If anyone else is trying to get this to happen, you just need to type in

Application.CommandBars("Name of tool bar").Visible = False

in sub workbook_before_close, and

Application.CommandBars("Materials Toolbar").Visible = True

in sub workbook_open