#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default excel's menu bar

how to hide/display menu bar ? is it possible?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,123
Default 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?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 663
Default 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?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 18
Default 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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Excel's scroll bar [email protected] Excel Discussion (Misc queries) 5 November 3rd 06 03:42 PM
Create Dropdown menu without using the Validation on the Data Menu lostinformulas Excel Worksheet Functions 0 July 13th 06 08:47 PM
Truncated font list in Excel's "Insert Symbol" menu selection OCM Excel Discussion (Misc queries) 1 February 13th 06 03:49 AM
Excel's Dialog Box Dialog Box Excel Discussion (Misc queries) 1 February 12th 05 12:53 PM
Menu items added with menu item editor in older versions Michael Hoffmann Excel Discussion (Misc queries) 2 January 7th 05 01:40 PM


All times are GMT +1. The time now is 09:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"