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>

end example]

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>