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