CellProtection property



Indicates whether protected cells in the sheet can be edited.

Syntax

Set:     Sheet.setCellProtection(isProtected)
Get: isProtected = Sheet.getCellProtection

Applies to

Sheet object.

Data type

boolean. The value is true if protection is turned on, and false otherwise.

Usage

To selectively protect or unprotect cells, use the Range property Protection. Then set CellProtection. When CellProtection is true, protected cells cannot be edited, but unprotected cells can still be edited.

See also
Protection property
cellProtection PARAM tag