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").Visibl e = True

--

HTH

Bob

"PJ" wrote in message
...
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.

Tools, Customize, Menu Bar, Reset

PJ wrote:

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.

You are missing a few others also.

Like Data and Window and Format to name three.

How did Favorites get there?

Go to ToolsCustomizeToolbars.

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


Gord Dibben MS Excel MVP

On Mon, 26 Apr 2010 08:49:02 -0700, PJ wrote:

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.

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

"Bob I" wrote:

Tools, Customize, Menu Bar, Reset

PJ wrote:

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.


.

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 Phillips" wrote:

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

Application.Commandbars(1).controls("View").Visibl e = True

--

HTH

Bob

"PJ" wrote in message
...
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.



.

It worked! Thanks so much for your help Gord!

"Gord Dibben" wrote:

You are missing a few others also.

Like Data and Window and Format to name three.

How did Favorites get there?

Go to ToolsCustomizeToolbars.

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


Gord Dibben MS Excel MVP

On Mon, 26 Apr 2010 08:49:02 -0700, PJ wrote:

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.

.

You're welcome, have a great day!

PJ wrote:

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

"Bob I" wrote:


Tools, Customize, Menu Bar, Reset

PJ wrote:


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.


.

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

--

HTH

Bob

"PJ" wrote in message
...
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 Phillips" wrote:

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

Application.Commandbars(1).controls("View").Visibl e = True

--

HTH

Bob

"PJ" wrote in message
...
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.



.