<protectedRanges> (Protected Ranges)

This collection specifies all protected ranges on this worksheet.

example:

This example demonstrates that A1:C5 have been protected, with no password specified.

<protectedRanges>
  <protectedRange sqref="A1:C5" name="Range1"/>
</protectedRanges>

Parent Elements

<worksheet> (§3.3.1.96)

Child Elements

Subclause

<protectedRange> (Protected Range)

§3.3.1.69

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_ProtectedRanges">
	<sequence>
	<element name="protectedRange" type="CT_ProtectedRange" minOccurs="1" maxOccurs="unbounded"/>
	</sequence>
</complexType>