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.