Printable View
I have made a button in my toolbar that automatically runs a macro. I am just trying to get that button to be saved to the document. The buttons only apear if I open the worksheet. If someone else opens it, the buttons don't apear (although you still can run the macro). I know how to do this with WORD, but I can't figure it out with EXCEL. Thanks
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?
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