Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deactivate workbook commandbar for one sheet?
I've never run into this one before. I usu. need a repeating toolbar
for any sheet in a workbook. Therefore, in the "ThisWorkbook" I copy this code into each new workbook I make that uses a custom commandbar: Private Sub Workbook_Activate() On Error Resume Next Application.CommandBars("My Assigned Toolbar Name").Visible = True End Sub Private Sub Workbook_Deactivate() ' CommandBars disappear (whilst the workbook remains open, but another is in view) On Error Resume Next Application.CommandBars("My Assigned Toolbar Name").Visible = False End Sub So that takes care of activating the custom toolbar on workbook open, and deactivating it on workbook close and the toolbar shows up on any sheet I create within that workbook. But, what does one do if one wants to "hide" the toolbar for sheet 2, say? Thanks. :oD |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Command Bar & Workbook Deactivate | Excel Programming | |||
Deactivate sheet | Excel Programming | |||
Workbook Deactivate | Excel Programming | |||
Workbook Deactivate Event | Excel Programming | |||
UserForms to deactivate workbook | Excel Programming |