Protection

Contents
[ ]

protection

Represents the various types of protection options available for a worksheet.

Property Name Property Type Nullable ReadOnly DefaultValue Description
AllowDeletingColumn Boolean True False Represents if the deletion of columns is allowed on a protected worksheet.
AllowDeletingRow Boolean True False Represents if the deletion of rows is allowed on a protected worksheet.
AllowFiltering Boolean True False Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.
AllowFormattingCell Boolean True False Represents if the formatting of cells is allowed on a protected worksheet.
AllowFormattingColumn Boolean True False Represents if the formatting of columns is allowed on a protected worksheet
AllowFormattingRow Boolean True False Represents if the formatting of rows is allowed on a protected worksheet
AllowInsertingColumn Boolean True False Represents if the insertion of columns is allowed on a protected worksheet
AllowInsertingHyperlink Boolean True False Represents if the insertion of hyperlinks is allowed on a protected worksheet
AllowInsertingRow Boolean True False Represents if the insertion of rows is allowed on a protected worksheet
AllowSorting Boolean True False Represents if the sorting option is allowed on a protected worksheet.
AllowUsingPivotTable Boolean True False Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
AllowEditingContent Boolean True False Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
AllowEditingObject Boolean True False Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
AllowEditingScenario Boolean True False Represents if the user is allowed to edit scenarios on a protected worksheet.
Password String True False Represents the password to protect the worksheet.
AllowSelectingLockedCell Boolean True False Represents if the user is allowed to select locked cells on a protected worksheet.
AllowSelectingUnlockedCell Boolean True False Represents if the user is allowed to select unlocked cells on a protected worksheet.