TROUBLE DISPLAYING CUSTOM TOOLBARS

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Woorkbook toolbar 2
Make custom buttons point to local macros always 2
Show Custom Toolbar on open 2
Keep custom toolbar settings - Help!! 4
Custom Toolbar does not display all buttons 2
excel custom menu persistence 1
Slow scroll with auto filter on 2
Custom Toolbar Visibility 2

Back
Top