ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Worksheet menu bar (https://www.excelbanter.com/excel-discussion-misc-queries/148372-worksheet-menu-bar.html)

Mark

Worksheet menu bar
 
My menu bar (File, Edit, Insert, etc) is "shaded" or greyed out and I cannot
access them. I can add a command icon to the bar and access that. Happens
with no file open or with any file open. Any ideas?
--
Mark

Gord Dibben

Worksheet menu bar
 
Try to right-click on a toolbar and CustomizeToolbarsWorksheet Menu BarReset

If no joy with that, with Excel closed, do a file search for your *.XLB file.

When you find it, rename to *.xlbold.

Ignore the warning message.

Re-start Excel.

Any luck with that?


Gord Dibben MS Excel MVP


On Thu, 28 Jun 2007 14:38:30 -0700, Mark wrote:

My menu bar (File, Edit, Insert, etc) is "shaded" or greyed out and I cannot
access them. I can add a command icon to the bar and access that. Happens
with no file open or with any file open. Any ideas?



Dave Peterson

Worksheet menu bar
 
Try rightclicking on an empty spot in any of the other toolbars.
Select customize
Select the Toolbars Tab
Select worksheet menu bar
Click Reset

If you've customized that toolbar, you'll have to do it again.

Mark wrote:

My menu bar (File, Edit, Insert, etc) is "shaded" or greyed out and I cannot
access them. I can add a command icon to the bar and access that. Happens
with no file open or with any file open. Any ideas?
--
Mark


--

Dave Peterson

Mark

Worksheet menu bar
 
Thanks for both replys. Im pretty sure I tried the reset but I will try it
again. If not I will try the other option. Thanks
Mark
--
Mark


"Dave Peterson" wrote:

Try rightclicking on an empty spot in any of the other toolbars.
Select customize
Select the Toolbars Tab
Select worksheet menu bar
Click Reset

If you've customized that toolbar, you'll have to do it again.

Mark wrote:

My menu bar (File, Edit, Insert, etc) is "shaded" or greyed out and I cannot
access them. I can add a command icon to the bar and access that. Happens
with no file open or with any file open. Any ideas?
--
Mark


--

Dave Peterson



All times are GMT +1. The time now is 09:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com