ShowFormulaBar Property

Gets or sets the value indicating whether Microsoft Excel will display the formula bar when the CustomView owning these window options is applied.

Syntax

Visual Basic

'Declaration
 
Public Property ShowFormulaBar As Boolean

C#

public bool ShowFormulaBar {get; set;}

Property Value

The value indicating whether Microsoft Excel will display the formula bar when the CustomView owning these window options is applied.

Remarks

Note: This setting cannot be saved with a Workbook in the Excel file. It can only be saved with a CustomView. Therefore, there is no corresponding property in WorkbookWindowOptions and calling Apply on the associated CustomView will not apply this property. Only by applying the custom view through the Microsoft Excel user interface will the setting on this property be applied.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2