Protection property



Indicates whether the cells in the referenced range are protected. When cells are protected and the CellProtection property for the sheet is true, the user cannot edit them.

Syntax

Set:     Range.setProtection(isProtected)
Get: isProtected = Range.getProtection

Applies to

Range object.

Data type

boolean. The value is true if any cells in the range are protected, and false otherwise.

Usage

Use Protection to selectively unprotect cells in a sheet and then set the Sheet property CellProtection to protect the rest of the sheet. For example, you could turn protection off for one range in the sheet and then protect the rest of the sheet.

See also
CellProtection property
cellProtection PARAM tag