ExcelSheetProtection Properties
From Office Open XML
The ExcelSheetProtection type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
 | 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.
|
