Turn off toolbars

[TJ]

Hi

I am writing an application in Excel 2003 and want to be able to
programmatically turn the toolbars on and off. Can anyone give any pointers
on how to do this?

Thanks
TJ

 

[Ron de Bruin]

Hi TJ

There are a few examples on this page
http://www.rondebruin.nl/menuid.htm

 

[Guest]

You can make them invisible as below or bay changing .visible to .enabled
simply grey them out, Don't forget to re-enable them.

Sub drastic()

With Application.CommandBars("Worksheet Menu Bar")
.Controls("&Edit").Visible = False
.Controls("&Window").Visible = False
.Controls("&Insert").Visible = False
.Controls("&File").Visible = False
.Controls("&View").Visible = False
.Controls("&Format").Visible = False
End With
End Sub

Mike