Protection element

Defines the protection properties of cells to which the defined style is applied.

Usage

      
<Protection
	Protected="TrueFalseType"
	x:HideFormula="[external type]"
/>

    

Element Information

Element type ProtectionType
Namespace urn:schemas-microsoft-com:office:spreadsheet
Schema name XML Spreadsheet 2002

Elements and Attributes

Parent Elements

Element Description
Style Defines a single style in the current workbook. This element is required for custom formatting; otherwise, it is optional.

Child Elements

None.

Attributes

Attribute Type Required Description Possible Values
Protected TrueFalseType optional Specifies whether a cell is protected. When the worksheet is unprotected, enabling protection on individual cells has no effect.
  • 0
  • 1
x:HideFormula external ref optional See external namespace. See external namespace.

Definition

      
<xsd:element name="Protection" type="ProtectionType" minOccurs="0" >
</xsd:element>


    
©2003-2004 Microsoft Corporation. All rights reserved. Permission to copy, display and distribute this document is available at: http://msdn.microsoft.com/library/en-us/odcXMLRef/html/odcXMLRefLegalNotice.asp