Turn On Formula Bar – Turn Off Formula Bar

September 17th, 2004 | Categories: General | Tags:
-->

When creating an Excel template you may want to turn off the formula bar to limit unwanted user actions.

If you are using a spreadsheet and the formula bar is missing you may want to turn it back on.

To toggle the formula bar On or Off:

On the main menu bar
1. Click Tools
2. Select Options
3. Select the View tab
4. Removing a checkmark next to the Formula bar option will remove the formula bar. Placing a checkmark next to the Formula bar option will add the formula bar. Click OK.

FormulaBarToggle

To do this from VBA take a look at Excel VBA: Turn On Formula Bar – Turn Off Formula Bar

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
  1. MichaelW
    January 19th, 2009 at 11:49
    Reply | Quote | #1

    What about when that doesn’t work? Formula bar stays gone, regardless of checkmark status…

  2. Nicole
    September 3rd, 2009 at 22:41
    Reply | Quote | #2

    Thank you!

  3. JasonW
    February 8th, 2010 at 18:46
    Reply | Quote | #3

    I though I was loosing my mind, thanks for the FYI, exactly what I needed!