Can't toggle (or display) formula bar

[Guest]

I used to have the Excel formula bar displayed, but after rebooting, it is
gone. The VIEW menu shows it checked, but I can't toggle that either.
Preferences set up to display it.

 

[VBA Noob]

Try the below code to see if this works

Sub Add_Formulabar()

Application.DisplayFormulaBar = True

End Sub

 

[Guest]

Is that supposed to be entered in a spreadsheet?

DS

 

[Guest]

I shut down Excel & restarted and the formula bar was there. Thanks.

ds

 

[Guest]

Hey, sorry for jumping in....

I have the same problem but do not know what to do with the code you so
kindly provided. Where does that get added?

Thanks very much for your time.

TH

 

[Gord Dibben]

Copy just the middle line of the code.

Application.DisplayFormulaBar = True

With Excel open, hit ALT + F11 to open VBE window.

View>Immediate Window

Paste the code and hit <ENTER>

ALT + Q to go back to Excel screen.

OK now?


Gord Dibben MS Excel MVP