Protection Properties

The Protection type exposes the following members.

Properties
  NameDescription
Public propertyAllowDeletingColumn
Represents if the deletion of columns is allowed on a protected worksheet.
Public propertyAllowDeletingRow
Represents if the deletion of rows is allowed on a protected worksheet.
Public propertyAllowEditingContent
Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
Public propertyAllowEditingObject
Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
Public propertyAllowEditingScenario
Represents if the user is allowed to edit scenarios on a protected worksheet.
Public propertyAllowFiltering
Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.
Public propertyAllowFormattingCell
Represents if the formatting of cells is allowed on a protected worksheet.
Public propertyAllowFormattingColumn
Represents if the formatting of columns is allowed on a protected worksheet
Public propertyAllowFormattingRow
Represents if the formatting of rows is allowed on a protected worksheet
Public propertyAllowInsertingColumn
Represents if the insertion of columns is allowed on a protected worksheet
Public propertyAllowInsertingHyperlink
Represents if the insertion of hyperlinks is allowed on a protected worksheet
Public propertyAllowInsertingRow
Represents if the insertion of rows is allowed on a protected worksheet
Public propertyAllowSelectingLockedCell
Represents if the user is allowed to select locked cells on a protected worksheet.
Public propertyAllowSelectingUnlockedCell
Represents if the user is allowed to select unlocked cells on a protected worksheet.
Public propertyAllowSorting
Represents if the sorting option is allowed on a protected worksheet.
Public propertyAllowUsingPivotTable
Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
Public propertyIsDeletingColumnsAllowed Obsolete.
Represents if the deletion of columns is allowed on a protected worksheet.
Public propertyIsDeletingRowsAllowed Obsolete.
Represents if the deletion of rows is allowed on a protected worksheet.
Public propertyIsEditingContentsAllowed Obsolete.
Represents if the user is allowed to edit contents of locked cells on a protected worksheet.
Public propertyIsEditingObjectsAllowed Obsolete.
Represents if the user is allowed to manipulate drawing objects on a protected worksheet.
Public propertyIsEditingScenariosAllowed Obsolete.
Represents if the user is allowed to edit scenarios on a protected worksheet.
Public propertyIsFilteringAllowed Obsolete.
Represents if the user is allowed to make use of an AutoFilter that was created before the sheet was protected.
Public propertyIsFormattingCellsAllowed Obsolete.
Represents if the formatting of cells is allowed on a protected worksheet.
Public propertyIsFormattingColumnsAllowed Obsolete.
Represents if the formatting of columns is allowed on a protected worksheet
Public propertyIsFormattingRowsAllowed Obsolete.
Represents if the formatting of rows is allowed on a protected worksheet
Public propertyIsInsertingColumnsAllowed Obsolete.
Represents if the insertion of columns is allowed on a protected worksheet
Public propertyIsInsertingHyperlinksAllowed Obsolete.
Represents if the insertion of hyperlinks is allowed on a protected worksheet
Public propertyIsInsertingRowsAllowed Obsolete.
Represents if the insertion of rows is allowed on a protected worksheet
Public propertyIsProtectedWithPassword
Indicates whether the worksheets is protected with password.
Public propertyIsSelectingLockedCellsAllowed Obsolete.
Represents if the user is allowed to select locked cells on a protected worksheet.
Public propertyIsSelectingUnlockedCellsAllowed Obsolete.
Represents if the user is allowed to select unlocked cells on a protected worksheet.
Public propertyIsSortingAllowed Obsolete.
Represents if the sorting option is allowed on a protected worksheet.
Public propertyIsUsingPivotTablesAllowed Obsolete.
Represents if the user is allowed to manipulate pivot tables on a protected worksheet.
Public propertyPassword
Represents the password to protect the worksheet.
See Also