TROUBLE DISPLAYING CUSTOM TOOLBARS
 

HOW DO YOU DISPLAY A CUSTOM TOOLBAR IN ONLY THE WORKBOOK YOU CREATED IT IN?
ATTACH DOES NOT WORK, THE TOOLBAR IS STILL DISPLAYED IN OTHER WORKBOOKS.

With that workbook active, right-click the excel LOGO near the file menu,
select View code, enter this:
Private Sub Workbook_Activate()
Application.CommandBars("TheCommandBarNameGoesHere ").Visible = True
End Sub

Private Sub Workbook_Deactivate()
Application.CommandBars("TheCommandBarNameGoesHere ").Visible = False
End Sub

Obviously, substitute the name you gave to the commandbar.
And yes, it'd be ok to use the Attach Toolbars along with the above code.

Bob Umlas
Excel MVP
I'm leading a FREE 1-hour online Webinar on Excel Tips & Tricks.
Dec 16, Jan 14, Jan 27 from 4-5PM (each session is the same).
If interested, go to http://www.iil.com, click on the yellow/orange
"Try a free webinar" link on the left side, click the Microsoft Excel
Tips & Tricks link, follow instructions to register.


"CHICAGOGLASSMAN" wrote in
message ...
HOW DO YOU DISPLAY A CUSTOM TOOLBAR IN ONLY THE WORKBOOK YOU CREATED IT
IN?
ATTACH DOES NOT WORK, THE TOOLBAR IS STILL DISPLAYED IN OTHER WORKBOOKS.