Stephen Esrati said:
I have tried to reopen the formula bar (which shows what you
have entered and where) from the Views Menu. It is checked
there, but the formula bar does not show up. Anyone have a
solution?
I have completely reinstalled Excel, but it made no difference.
Note that you should always note which version of XL you're using.
In this case, try deleting the
Excel Toolbars (n)
file (where n = 8 for XL98, 9 for XL01, 10 for XLv.X) file from the
Preferences:Microsoft folder. Make sure XL is closed at the time (or it
will simply write the old file back).
If that doesn't work, type OPT-F11 to enter the Visual Basic Editor.
Type CMD-G to open the Immediate Window. Enter or Paste these lines into
the Immediate Window, each followed by Return.
Commandbars("Formula Bar").Enabled = True
Commandbars("Formula Bar").Reset
Commandbars("Formula Bar").Visible = True
Commandbars("Formula Bar").Top = 100
Commandbars("Formula Bar").Left = 100
then type OPT-F11 to return to XL. Dock the formula bar if desired.
If you want to "permanently" dock the formula bar, check out
http://www.mcgimpsey.com/macoffice/excel/locktoolbars.html
