Excel VBA: Hiding the Formula Bar

This Excel VBA macro hides the formula bar.

Macro Example

Sub HideFormulaBar()

  Application.DisplayFormulaBar = False

End Sub

Description

Application

  Application...

The Application property returns an Application object.

Application.DisplayFormulaBar

  Application.DisplayFormulaBar...

The Application.DisplayFormulaBar property returns True if the formula bar is displayed.

In this macro, I’m setting it to False so that the formula bar is hidden.

Sub HideFormulaBar()

  Application.DisplayFormulaBar = False

End Sub

Properties

http://www.relief.jp/itnote/archives/000781.php

Apply to

• Excel 2013
• Excel 2010
• Excel 2007