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