excel's menu bar

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Rosa

Manual

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