Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel's menu bar
how to hide/display menu bar ? is it possible?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel's scroll bar | Excel Discussion (Misc queries) | |||
Create Dropdown menu without using the Validation on the Data Menu | Excel Worksheet Functions | |||
Truncated font list in Excel's "Insert Symbol" menu selection | Excel Discussion (Misc queries) | |||
Excel's Dialog Box | Excel Discussion (Misc queries) | |||
Menu items added with menu item editor in older versions | Excel Discussion (Misc queries) |