ProtectedRange

ProtectedRange class

A specified range to be allowed to edit when the sheet protection is ON.

Properties

Name	Type	Description
Name	String	Gets the Range title. This is used as a descriptor, not as a named range definition.
CellArea	CellArea	Gets the CellArea object represents the cell area to be protected.
IsProtectedWithPassword	boolean	Indicates whether the worksheets is protected with password.
Password	String	Represents the password to protect the range.
SecurityDescriptor	String	The security descriptor defines user accounts who may edit this range without providing a password to access the range.

Methods

Name	Description
getAreas	Gets all referred areas.
addArea	Adds a referred area to this

ProtectedRange.Name property

Gets the Range title. This is used as a descriptor, not as a named range definition.

Type: String

ProtectedRange.CellArea property

Gets the CellArea object represents the cell area to be protected.

Type: CellArea

ProtectedRange.IsProtectedWithPassword property

Indicates whether the worksheets is protected with password.

Type: boolean

ProtectedRange.Password property

Represents the password to protect the range.

Type: String

ProtectedRange.SecurityDescriptor property

The security descriptor defines user accounts who may edit this range without providing a password to access the range.

Type: String

getAreas()

Gets all referred areas.

Returns: Returns all referred areas.

addArea(startRow, startColumn, endRow, endColumn)

Adds a referred area to this

Parameter	Type	Description
startRow	int	The start row.
startColumn	int	The start column.
endRow	int	The end row.
endColumn	int	The end column.