Formula Bar Missing

[Angie]

My formula bar has disappeared! I can't retrieve it with the view>formula
bar command. I tried trashing the tool bar file and it didn't do anything.
Any other suggestions would be most helpful.

Mahalo

 

[Jon Peltier]

Try Options from the Tools menu, click on the View tab, and check
Formula Bar in the top row.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Angie]

I did this and it still doesn't show up. I thought the toolbar file might be
corrupt so I tried to trash it and start over, but that still didn't work. I may
be running out of options, but if you know of any other way to get it back,
that would be great.

 

[Myrna Larson]

If all else fails, try searching for all files with the extension .XLB. Move
it/them to a different directory. If Excel now opens with the Formula bar
visible, or you can turn it on from the View menu, then your XLB file is
corrupt. In this case, you might want to put it back where it came from, open
Excel and note whether there are any custom changes that you want to
re-create, then delete the XLB file and redo your changes.

 

[David McRitchie]

Hi Angie,
Something else to try:

Right click on the worksheet tab
View code

insert the following code (only one Option Explicit)

Option Explicit
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
If Application.DisplayFormulaBar = False Then
Application.DisplayFormulaBar = True
Else
Application.DisplayFormulaBar = False
End If
End Sub

Then double-click on a worksheet cell.
You have to have macros turn turned on.

--

 

[David McRitchie]

or from the VBE (Visual Basic Editor)
Ctrl+G to get to the intermediate window

paste the following line in and hit Enter (a little harder than I tried before)
Application.DisplayFormulaBar = True


I did this and it still doesn't show up. I thought the toolbar file might be
corrupt so I tried to trash it and start over, but that still didn't work. I may