Where is my Formula Bar?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Hi Su,

Tools>Options>View>Formula Bar

Biff
-----Original Message-----
My formula bar no longer shows up when I click on a cell.
Click to expand...
Toggling the Formula Bar selection under the View menu has
no effect at all. My formula bar is gone.
 
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.
Click to expand...
Toggling the Formula Bar selection under the View menu has
no effect at all. My formula bar is gone.
 
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.
 
Type Opt-F11 to enter the Visual Basic Editor.

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