Missing Excel option

  • Thread starter Thread starter PJ
  • Start date Start date
P

PJ

Somehow the "View" option in Excel went missing. Now there's a thin white
line where the word use to be. So the it reads: File Edit (white bar)
Favorites Tools Help. Does anyone know how to fix this? Thanks.
 
Try going into the VBIDE (alt-F11), open the immediate window (Ctrl-G), and
enter

Application.Commandbars(1).controls("View").Visible = True
 
You are missing a few others also.

Like Data and Window and Format to name three.

How did Favorites get there?

Go to Tools>Customize>Toolbars.

Scroll down to and select Worksheet Menu Bar and "Reset"


Gord Dibben MS Excel MVP
 
This worked! Had to uncheck, and then check Worksheet Menu Bar, but it
worked. Thanks Bob I for your help!
 
It worked! Thanks so much for your help Gord!

Gord Dibben said:
You are missing a few others also.

Like Data and Window and Format to name three.

How did Favorites get there?

Go to Tools>Customize>Toolbars.

Scroll down to and select Worksheet Menu Bar and "Reset"


Gord Dibben MS Excel MVP



.
Click to expand...
 
Actually the Toolbars, Customize, Worksheet Menu, Reset trick worked, but I
appreciate your taking the time to try to help me out. Thanks Bob!
 
Of course it does, but it resets the whole menu, so it destroys any required
customisations.
 
Back
Top