VBA: Turn On Formula Bar – Turn Off Formula Bar

October 10th, 2004 | Categories: VBA | Tags:

-->

I recently posted how to manually Turn On Formula Bar – Turn Off Formula Bar. Here is how to do it with VBA:

Macro to turn off the formula bar:

Sub OffFormulaBar()
    Application.DisplayFormulaBar = False
End Sub

Macro to turn on the formula bar:

Sub OnFormulaBar()
    Application.DisplayFormulaBar = True
End Sub

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!