Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide all toolbar buttons
Is the a quick method to hide all toolbar buttons whilst a particular workbook remains open??
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide all toolbar buttons
Assuming you meant to hide buttons on the Worksheet Menu
Bar only then I think the following is what you're looking for. Paste to the ThisWorkbook module of the workbook involved. Private Sub Workbook_Open() Dim Btn As CommandBarControl For Each Btn In Application.CommandBars(1).Controls If Btn.Type = msoControlButton Then Btn.Visible = False Next End Sub Private Sub Workbook_Deactivate() Dim Btn As CommandBarControl For Each Btn In Application.CommandBars(1).Controls If Btn.Type = msoControlButton Then Btn.Visible = True Next End Sub Regards, Greg -----Original Message----- Is the a quick method to hide all toolbar buttons whilst a particular workbook remains open?? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Toolbar buttons to hide/unhide sheets | Excel Discussion (Misc queries) | |||
pivot chart is it possible to hide individual field buttons? Layout Field buttons | Charts and Charting in Excel | |||
Toolbar Buttons | Excel Discussion (Misc queries) | |||
saving toolbar buttons on custom toolbar | Excel Programming | |||
Toolbar Buttons | Excel Programming |