NamedRange::FormulaHidden Property

 

Gets or sets a value that indicates whether the formula in the NamedRange control will be hidden when the worksheet is protected.

Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)

C#
C++
F#
VB
Copy 
property Object^ FormulaHidden {
	Object^ get();
	void set(Object^ value);
}

Property Value

Type: System::Object^

true if the formula will be hidden when the worksheet is protected; null if the NamedRange control contains some cells with FormulaHidden equal to true and some cells with FormulaHidden equal to false.

Do not confuse this property with the Hidden property. The formula will not be hidden if the workbook is protected and the worksheet is not.

The following code example sets the Formula property of a NamedRange control to calculate the sum of cells A1 through A5, uses the FormulaHidden property to hide the formula, and then calls the Calculate method to calculate the sum of the cells and place the sum in cell A6.

This example is for a document-level customization.

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.
Return to top
Show: