DisplayFormat.FormulaHidden property (Excel)

Returns a value that indicates if the formula of the associated Range object is hidden when the worksheet is protected as it is displayed in the current user interface. Read-only.

Syntax

expression.FormulaHidden

expression A variable that represents a DisplayFormat object.

Return value

Variant

Remarks

Returns True if the formula is hidden when the worksheet is protected.

Returns Null if the range contains some cells with FormulaHidden equal to True and some cells with FormulaHidden equal to False.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.