HiddenFormula Property (Protection)

Gets or sets if the content of a Cell or the formula are displayed in the formula bar or not. The default value is false.

Syntax

Visual Basic
C#

'Declaration

 

Public Property HiddenFormula As Boolean

'Usage

 

Dim instance As Protection

Dim value As Boolean

 

instance.HiddenFormula = value

 

value = instance.HiddenFormula

public bool HiddenFormula {get; set;}

Remarks

The associated Worksheet needs to be protected in order for this property to take effect. You can protect a Worksheet with a call to the Worksheet.Protect() method.

Requirements

Target Platforms: Windows 11, Windows 10, Windows 7, 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

Reference

Protection Class
Protection Members