Missing Excel option

[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.

 

[Bob Phillips]

Try going into the VBIDE (alt-F11), open the immediate window (Ctrl-G), and
enter

Application.Commandbars(1).controls("View").Visible = True

 

[Bob I]

Tools, Customize, Menu Bar, Reset

 

[Gord Dibben]

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

 

[PJ]

This worked! Had to uncheck, and then check Worksheet Menu Bar, but it
worked. Thanks Bob I for your help!

 

[PJ]

It worked! Thanks so much for your help Gord!

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



.

 

[PJ]

Actually the Toolbars, Customize, Worksheet Menu, Reset trick worked, but I
appreciate your taking the time to try to help me out. Thanks Bob!

 

[Bob I]

You're welcome, have a great day!

This worked! Had to uncheck, and then check Worksheet Menu Bar, but it
worked. Thanks Bob I for your help!

:

 

[Bob Phillips]

Of course it does, but it resets the whole menu, so it destroys any required
customisations.