Returns the value that indicates whether the Worksheet is protected. Read-only Boolean.
Syntax
property IsProtected: boolean;
Example
This example checks whether a worksheet is protected before updating a
range. Worksheet protection is independent from workbook protection.
var
Sheet: IXLSWorksheet;
begin
Sheet := Workbook.Sheets[1];
if Sheet.IsProtected then
Sheet.UnProtect;
Sheet.Range['A1', 'A1'].Value := 'Updated';
end;
See also