Formula bar disappeared--VIEW menu no help

[Ann Norcross]

OSX 10.3.5
Microsoft Office 2004 for Mac
PowerPC G4

Not sure what's happened, but my formula bar is no longer displayed.
Selecting FORMULA BAR from the VIEW menu has no effect. Help! I really need
to be able to see my formula bar.

Any thoughts greatly appreciated.

Ann

 

[JE McGimpsey]

Not sure what's happened, but my formula bar is no longer displayed.
Selecting FORMULA BAR from the VIEW menu has no effect. Help! I really need
to be able to see my formula bar.

Any thoughts greatly appreciated.

What version of XL (I'll assume XL04)?

By "no effect" do you mean that the bar isn't visible even though
there's a checkmark next to it? Or that the checkmark doesn't appear?

You can try this:

Type OPT-F11 to enter the Visual Basic Editor. Type CMD-G to open the
Immediate Window. In the Immediate Window, type or paste the following,
one line at a time, ending each by pressing Return:

Commandbars("Formula Bar").Reset
Commandbars("Formula Bar").Enabled = True
Commandbars("Formula Bar").Visible = True

Type Opt-F11 to return to XL.

It's remotely possible that, if you undocked the Standard toolbar, the
Formula bar has slipped up underneath. On my setup, however, that's
pretty visible...

An alternative, if you don't mind losing any toolbar customizations, is
to close XL, then delete the

~:Libraryreference:Microsoft:Excel Toolbars (11)

file (where ~ is your home directory).

 

[Ann Norcross]

What version of XL (I'll assume XL04)?

Office 2004 for Mac

By "no effect" do you mean that the bar isn't visible even though
there's a checkmark next to it?

Correct. And I tried checking and unchecking several times to no avail.

You can try this:

Too scary

Type OPT-F11 to enter the Visual Basic Editor. Type CMD-G to open the
Immediate Window. In the Immediate Window, type or paste the following,
one line at a time, ending each by pressing Return:

Commandbars("Formula Bar").Reset
Commandbars("Formula Bar").Enabled = True
Commandbars("Formula Bar").Visible = True

Type Opt-F11 to return to XL.

It's remotely possible that, if you undocked the Standard toolbar, the
Formula bar has slipped up underneath. On my setup, however, that's
pretty visible...

I looked... Not there.

An alternative, if you don't mind losing any toolbar customizations, is
to close XL, then delete the

~:Libraryreference:Microsoft:Excel Toolbars (11)

file (where ~ is your home directory).

Worked perfectly... Thanks so much.