Hide toolbars

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

Guest

Is there VBA code similar to

Application.CommandBars(1).Enabled = False

but to hide all the toolbar icons

Thanks in anticipation
 
For example, to hide the "View" menu:

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

- Piku
 
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
 
Back
Top