Vanishing Formula Bar

P

PopeSammyJoe

This is driving me insane. I can't get the formula bar to appear. No
matter how many times I click the View --> Formula Bar menu item, I
can't get the formula bar to appear. The check appears next to
"Formula Bar" in the menu cell, but no Formula Bar is anywhere.

Any pointers would be appreciated.

Thanks ...
 
J

JE McGimpsey

This is driving me insane. I can't get the formula bar to appear. No
matter how many times I click the View --> Formula Bar menu item, I
can't get the formula bar to appear. The check appears next to
"Formula Bar" in the menu cell, but no Formula Bar is anywhere.

Any pointers would be appreciated.
Click to expand...

Not sure what the problem is, but this should reset the Formula bar:

Type Opt-F11 to enter the Visual Basic Editor. Type CMD-G to open the
Immediate window. Paste or type into the immediate window, each line
followed by a Return:

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

Type Opt-F11 to return to XL.
 
Top