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.

obj-Excel-Global-Application

Application.DisplayFormulaBar

  Application.DisplayFormulaBar...

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

obj-Excel-Application-DisplayFormulaBar

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