Hide menus etc in Excel 2007
How can I convert the following to hide the menus and ribbon in Excel
2007?
**********
Dim Wksht As Worksheet
With Application
.DisplayFormulaBar = False
.CommandBars("Worksheet Menu Bar").Enabled = False
.CommandBars("Standard").Visible = False
.CommandBars("Formatting").Visible = False
.CommandBars("Drawing").Visible = False
End With
**********
Thanks
Sandy
|