ExcelSheetProtection Members

Office Open XML

The ExcelSheetProtection type exposes the following members.

Methods

  NameDescription
Equals
Determines whether the specified Object is equal to the current Object.
(Inherited from Object.)
GetHashCode
Serves as a hash function for a particular type.
(Inherited from Object.)
GetType
Gets the Type of the current instance.
(Inherited from Object.)
SetPassword
Sets a password for the sheet.
ToString
Returns a String that represents the current Object.
(Inherited from Object.)

Properties

  NameDescription
AllowAutoFilter
Allow users to use autofilters
AllowDeleteColumns
Allow users to delete columns
AllowDeleteRows
Allow users to delete rows
AllowEditObject
Allow users to edit objects
AllowEditScenarios
Allow users to edit senarios
AllowFormatCells
Allow users to format cells
AllowFormatColumns
Allow users to Format columns
AllowFormatRows
Allow users to Format rows
AllowInsertColumns
Allow users to insert columns
AllowInsertHyperlinks
Allow users to insert hyperlinks
AllowInsertRows
Allow users to Format rows
AllowPivotTables
Allow users to use pivottables
AllowSelectLockedCells
Allow users to select locked cells
AllowSelectUnlockedCells
Allow users to select unlocked cells
AllowSort
Allow users to sort a range
IsProtected
If the worksheet is protected.

See Also