I have created customized toolbar “Specific Workbook” to be linked to a specific workbook. How can I display “Specific Workbook” toolbar upon opening “Specific Workbook.xlsm?” When any other workbook is opened their default Excel toolbar will be displayed.
I tried Workbook_Open and Workbook_Activate private subs with Application. CommandBars and I couldn’t get it to work.
I found the code below on this website and slightly modified it.
Private Sub Workbook_Activate(ByVal Wn As Window)
Application.CommandBars(“Specific Workbook”).Visible = True
End Sub
Private Sub Workbook_Deactivate(ByVal Wn As Window)
Application.CommandBars(“Specific Workbook”).Visible = False
End Sub
I couldn’t get the above routine to work.
What I need is a routine that will display “Specific Workbook” toolbar when "Specific Workbook”.xlsm" is opened if the user opens any other workbook their default toolbar will be displayed.
Any suggestions?
Thanks for your responses
Ed
Bookmarks