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

Hi TJ

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

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"TJ" wrote in message ...
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

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


"TJ" wrote:

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