Where is my Formula Bar?

[Su Elliott]

My formula bar no longer shows up when I click on a cell. Toggling the Formula Bar selection under the View menu has no effect at all. My formula bar is gone.

How can I retrieve it?

 

[Biff]

Hi Su,

Tools>Options>View>Formula Bar

Biff

-----Original Message-----
My formula bar no longer shows up when I click on a cell.

Toggling the Formula Bar selection under the View menu has
no effect at all. My formula bar is gone.

 

[Su Elliott]

As I said in my first message, I already tried that.

----- Biff wrote: -----

Hi Su,

Tools>Options>View>Formula Bar

Biff

-----Original Message-----
My formula bar no longer shows up when I click on a cell.

Toggling the Formula Bar selection under the View menu has
no effect at all. My formula bar is gone.

 

[J.E. McGimpsey]

Actually, you said you tried using the View menu - Biff was
suggesting using the Options dialog, View tab. They both should do
the same thing, however.

Try this:

Type Opt-F11 to enter the Visual Basic Editor. Choose View/Immediate
Window. Type or paste the following lines into the Immediate Window
and press Enter after each line:

CommandBars("formula bar").Enabled = True

CommandBars("formula bar").Visible = True

Type Opt-F11 to return to XL.

 

[Su Elliott]

Ah! I threw away the Excel settings file and all is restored.

 

[Max]

Type Opt-F11 to enter the Visual Basic Editor.

Just curious. Can't seem to find the key "Opt" but can find "Alt" <g>

 

[J.E. McGimpsey]

Damn Macophiles....