Can't toggle (or display) formula bar

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
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
 
Back
Top