Posted to microsoft.public.excel.programming

external usenet poster

Posts: 270

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sub-menus of main menus for Excel 2007	Eleanor Peppard	New Users to Excel	1	March 16th 10 04:12 PM
Excel 2007 menus - how can I get rid of them?	Vic Baron	New Users to Excel	4	August 21st 08 04:15 PM
Excel 2007 Menus	JasonB	Excel Programming	2	August 29th 07 03:11 PM
Excel 2007 menus - XML Notepad 2007	michael.beckinsale	Excel Programming	5	February 13th 07 08:15 PM
Excel 2007 menus - is this right?	michael.beckinsale	Excel Programming	5	February 5th 07 04:09 PM

All times are GMT +1. The time now is 07:19 PM.

About Us

"It's about Microsoft Excel"