ProtectedRange
ProtectedRange class
A specified range to be allowed to edit when the sheet protection is ON.
Methods
| Name | Description |
|---|---|
| addArea(startRow, startColumn, endRow, endColumn) | Adds a referred area to this |
| getAreas() | Gets all referred areas. |
| getCellArea() | Gets the CellArea object represents the cell area to be protected. |
| getName() | Gets the Range title. This is used as a descriptor, not as a named range definition. |
| getPassword() | Represents the password to protect the range. |
| getSecurityDescriptor() | The security descriptor defines user accounts who may edit this range without providing a password to access the range. |
| isProtectedWithPassword() | Indicates whether the worksheets is protected with password. |
| setName() | Gets the Range title. This is used as a descriptor, not as a named range definition. |
| setPassword() | Represents the password to protect the range. |
| setSecurityDescriptor() | The security descriptor defines user accounts who may edit this range without providing a password to access the range. |
addArea(startRow, startColumn, endRow, endColumn)
Adds a referred area to this
| Parameter | Type | Description |
|---|---|---|
| startRow | Number | The start row. |
| startColumn | Number | The start column. |
| endRow | Number | The end row. |
| endColumn | Number | The end column. |
getAreas()
Gets all referred areas.
Returns: Array ofCellArea — Array ofCellArea Returns all referred areas.
getCellArea()
Gets the CellArea object represents the cell area to be protected.
getName()
Gets the Range title. This is used as a descriptor, not as a named range definition.
getPassword()
Represents the password to protect the range.
getSecurityDescriptor()
The security descriptor defines user accounts who may edit this range without providing a password to access the range.
isProtectedWithPassword()
Indicates whether the worksheets is protected with password.
setName()
Gets the Range title. This is used as a descriptor, not as a named range definition.
setPassword()
Represents the password to protect the range.
setSecurityDescriptor()
The security descriptor defines user accounts who may edit this range without providing a password to access the range.