Hide toolbars
 

Is there VBA code similar to

Application.CommandBars(1).Enabled = False

but to hide all the toolbar icons

Thanks in anticipation

Hide toolbars
 

For example, to hide the "View" menu:

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

- Piku

--
Message posted from http://www.ExcelForum.com

Hide toolbars
 

but to hide all the toolbar icons?

Do you mean all toolbars??

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Lawlera" wrote in message ...
Is there VBA code similar to

Application.CommandBars(1).Enabled = False

but to hide all the toolbar icons?

Thanks in anticipation

Hide toolbars
 

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


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"lawlera" wrote in message ...
Yes!!