Turn off toolbars

  • Thread starter Thread starter TJ
  • Start date Start date
T

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