Hide toolbars

L

Lawlera

Is there VBA code similar to

Application.CommandBars(1).Enabled = False

but to hide all the toolbar icons

Thanks in anticipation
 
P

pikus

For example, to hide the "View" menu:

Application.CommandBars("Worksheet Menu Bar").Controls("View").Visibl
= False

- Piku
 
R

Ron de Bruin

Hi lawlera

Use this then
It also hide the Worksheet menu bar

Sub hide()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = False
Next
End Sub

Sub show()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = True
Next
End Sub
 
Top