Gets or sets a value that indicates whether the Formula in the range will be
hidden when the Worksheet is protected. True if the Formula will be
hidden when the Worksheet is protected.
Syntax
property FormulaHidden: boolean;
Remarks
The Formula will not be hidden if the Workbook is protected and the Worksheet is not.
Example
This example sets the Formula of cell A6 to calculate the sum of cells A1 through A5, uses the FormulaHidden property to hide the Formula.
With Workbook.Sheets[1].Cells[6,1] do
begin
Formula := '=SUM(A1:A5)';
FormulaHidden := true;
end;