Name box/Fomula bar disappeared

[Charlie]

The foumula bar disappeared. I have gone to view > and clicked on
fomular bar, I have also gone to Excel Preferences > View and checked
the Formula bar box. Nothing seems to work, it will not appear. Does
anyone have a suggestion for the formular bar to re-appear? I am
running 10.3. Thanks

 

[JE McGimpsey]

The foumula bar disappeared. I have gone to view > and clicked on
fomular bar, I have also gone to Excel Preferences > View and checked
the Formula bar box. Nothing seems to work, it will not appear. Does
anyone have a suggestion for the formular bar to re-appear? I am
running 10.3. Thanks

You don't say which version of XL, so I'll assume 2004. One way:

With XL closed, delete the

~:Libraryreferences:Excel Toolbars (11)

file, where ~ indicates your home directory. Empty the trash, then start
Note that this will remove any toolbar customizations.

As an alternative, type Opt-F11 to enter the Visual Basic Editor. Type
CMD-g to open the Immediate Window. Type or Paste the following lines
into the Immediate Window, following each with a Return:

CommandBars("Formula Bar").Reset

Commandbars("Formula Bar").Enabled = True

CommandBars("Formula Bar").Visible = True

Type Opt-F11 (or click the XL control in the toolbar) to return to XL.

 

[Charlie]

JE: Thank you very much for your reply. Your asumption is correct, I
am running the XL 2004 version.

1. As recommended, I emptyed the Trash.

2. Went to Library..etc...There was no Excel Toolbars (11) but there
was a (10) and I did not delete the (10),

3. For your alternative, I couldn't determine where to type the
Opt-F11. and the other commands you suggested. Would you please
inform me where that would be, I need the basics.

thanks

chalrlie

 

[JE McGimpsey]

For your alternative, I couldn't determine where to type the
Opt-F11. and the other commands you suggested. Would you please
inform me where that would be, I need the basics.

With an XL sheet active, and not in Edit Mode, type Opt-F11 to open the
Visual Basic Editor.

 

[Charlie]

JE:

Followed your instructions, typed the 3 commands and hit the Opt & F11
keys but the formula bar did not appear. Any other suggestions?
Thank you

 

[JE McGimpsey]

Followed your instructions, typed the 3 commands and hit the Opt & F11
keys but the formula bar did not appear. Any other suggestions?

Did you follow each command with Return?

Are you sure it's not visible, but hidden under another toolbar?

I've never had these steps fail, so if it's not, try, with all Office
apps closed, renaming the

~/Library/Preference/Microsoft

folder, then restart XL. If the formula bar is back, transfer Word,
Entourage and Powerpoint files to the new Microsoft folder.

 

[Charlie]

JE:

Thanks, everything is working fine now.

charlie