[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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

worksheet3.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>