Missing Excel option
 

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.

Missing Excel option
 

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.

Missing Excel option
 

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.

Missing Excel option
 

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.

Missing Excel option
 

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.


.

Missing Excel option
 

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.



.

Missing Excel option
 

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.

.

Missing Excel option
 

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.


.

Missing Excel option
 

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.



.