Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Getting Excel 2003 to save Custom Toolbars | Excel Discussion (Misc queries) | |||
Custom Header | Excel Discussion (Misc queries) | |||
Cant add an icon to toolbars | Excel Discussion (Misc queries) |