View Single Post
  #2   Report Post  
Bob Umlas
 
Posts: n/a
Default

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.