The following tables list the members exposed by WorksheetProtection.
Name | Description | |
---|---|---|
![]() | AllowDeletingColumns | Returns a boolean indicating if the deletion of columns is allowed in a protected worksheet. |
![]() | AllowDeletingRows | Returns a boolean indicating if the deletion of rows is allowed in a protected worksheet. |
![]() | AllowedEditRanges | Returns a collection of WorksheetProtectedRange instances that define which locked ranges of cells may be edited in a protected worksheet. |
![]() | AllowEditObjects | Returns a boolean indicating if objects such as shapes, comments, charts and controls may be created or changed when the worksheet is protected. |
![]() | AllowEditScenarios | Returns a boolean indicating if existing scenarios are protected when the worksheet is protected. |
![]() | AllowFiltering | Returns a boolean indicating if the user may use an auto filter created before the worksheet was protected. |
![]() | AllowFormattingCells | Returns a boolean indicating if the user may change the formatting of cells in a protected worksheet. |
![]() | AllowFormattingColumns | Returns a boolean indicating if the user may change column information such as its width or visibility in a protected worksheet. |
![]() | AllowFormattingRows | Returns a boolean indicating if the user may change row information such as its height or visibility in a protected worksheet. |
![]() | AllowInsertingColumns | Returns a boolean indicating if the user may insert columns in a protected worksheet. |
![]() | AllowInsertingHyperlinks | Returns a boolean indicating if the user may insert hyperlinks in unlocked cells in a protected worksheet. |
![]() | AllowInsertingRows | Returns a boolean indicating if the user may insert rows in a protected worksheet. |
![]() | AllowSorting | Returns a boolean indicating if the sorting is allowed in a protected worksheet. |
![]() | AllowUsingPivotTables | Returns a boolean indicating if the user can change pivot tables in a protected worksheet. |
![]() | SelectionMode | Returns or sets an enumeration used to indicate how cell selection should be affected when the associated Worksheet is protected. |
Name | Description | |
---|---|---|
![]() | PropertyChanged | Occurs after a property value has changed (Inherited from Infragistics.Documents.Excel.SheetProtection) |
WorksheetProtection Class
Infragistics.Documents.Excel Namespace
Worksheet.HasProtectionPassword
Worksheet.IsProtected
Protection Property
Protect Method
Worksheet.Unprotect()