| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet menu bar
I've been trying out ways to remove the Worksheet Menu Bar and only display
customized toolbars, when a certain Excel workbook is activated. ( This was achieved by downloading examples & trying them out to suit my needs ) All was ok but now the Worksheet Menu Bar as dissapeared ! from all workbooks, even if I open a new one. What have I done ? Help please |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet menu bar
Hi Labrev,
To restore, try: Application.CommandBars("Worksheet Menu Bar").Enabled =True --- Regards, Norman "labrev" wrote in message ... I've been trying out ways to remove the Worksheet Menu Bar and only display customized toolbars, when a certain Excel workbook is activated. ( This was achieved by downloading examples & trying them out to suit my needs ) All was ok but now the Worksheet Menu Bar as dissapeared ! from all workbooks, even if I open a new one. What have I done ? Help please |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet menu bar
Hi Labrev
For more information look here http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Labrev, To restore, try: Application.CommandBars("Worksheet Menu Bar").Enabled =True --- Regards, Norman "labrev" wrote in message ... I've been trying out ways to remove the Worksheet Menu Bar and only display customized toolbars, when a certain Excel workbook is activated. ( This was achieved by downloading examples & trying them out to suit my needs ) All was ok but now the Worksheet Menu Bar as dissapeared ! from all workbooks, even if I open a new one. What have I done ? Help please |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Worksheet menu bar
Norman & Ron
Many thanks for the speedy reply. Quality forum ! "Ron de Bruin" wrote: Hi Labrev For more information look here http://www.rondebruin.com/menuid.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Norman Jones" wrote in message ... Hi Labrev, To restore, try: Application.CommandBars("Worksheet Menu Bar").Enabled =True --- Regards, Norman "labrev" wrote in message ... I've been trying out ways to remove the Worksheet Menu Bar and only display customized toolbars, when a certain Excel workbook is activated. ( This was achieved by downloading examples & trying them out to suit my needs ) All was ok but now the Worksheet Menu Bar as dissapeared ! from all workbooks, even if I open a new one. What have I done ? Help please |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create a worksheet menu to select each other worksheet | Excel Discussion (Misc queries) | |||
| New Menu on Worksheet & Chart Menu Bars | Excel Programming | |||
| Worksheet Menu Bar | Excel Programming | |||
| linking chart menu bars and worksheet menu bars | Excel Programming | |||
| chart menu bar vs worksheet menu bar | Excel Programming | |||
Linear Mode
