excel's menu bar
 

how to hide/display menu bar ? is it possible?

excel's menu bar
 

Hi Rosa

Manual

ToolsCustomize
on the Toolbars tab uncheck "worksheet Menu Bar"


With code

Application.CommandBars("Worksheet Menu Bar").Enabled = False

Set it to True if you want it back



--

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


"rosa" wrote in message ...
how to hide/display menu bar ? is it possible?

excel's menu bar
 

Hi,

Important: You can hide a Worksheet menu bar only if have a work book
opened. You cannot hide menu bar without any workbook.

Follow the procedure to hide the Worksheet Menu bar:

1. Move your mouse pointer to the left of the Menu bar - Worksheet Menu bar.
2. The pointer changes to a four headed arrow.
3. Drag the Worksheet Menu bar in the worsheet area - Content area.
4. Click the close window icon (X). to hide the Worksheet Menu bar.

Challa Prabhu


"rosa" wrote:

how to hide/display menu bar ? is it possible?

excel's menu bar
 

Sub Auto_open()
Application.CommandBars("Worksheet Menu Bar").Enabled = False
End Sub

"rosa" wrote:

how to hide/display menu bar ? is it possible?