![]() |
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 |
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 |
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 |
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 |
All times are GMT +1. The time now is 10:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com