Version 20.1 (latest)

WorksheetProtection Class Properties

For a list of all members of this type, see WorksheetProtection members.

Public Properties
 NameDescription
Public PropertyAllowDeletingColumnsReturns a boolean indicating if the deletion of columns is allowed in a protected worksheet.  
Public PropertyAllowDeletingRowsReturns a boolean indicating if the deletion of rows is allowed in a protected worksheet.  
Public PropertyAllowedEditRangesReturns a collection of WorksheetProtectedRange instances that define which locked ranges of cells may be edited in a protected worksheet.  
Public PropertyAllowEditObjectsReturns a boolean indicating if objects such as shapes, comments, charts and controls may be created or changed when the worksheet is protected.  
Public PropertyAllowEditScenariosReturns a boolean indicating if existing scenarios are protected when the worksheet is protected.  
Public PropertyAllowFilteringReturns a boolean indicating if the user may use an auto filter created before the worksheet was protected.  
Public PropertyAllowFormattingCellsReturns a boolean indicating if the user may change the formatting of cells in a protected worksheet.  
Public PropertyAllowFormattingColumnsReturns a boolean indicating if the user may change column information such as its width or visibility in a protected worksheet.  
Public PropertyAllowFormattingRowsReturns a boolean indicating if the user may change row information such as its height or visibility in a protected worksheet.  
Public PropertyAllowInsertingColumnsReturns a boolean indicating if the user may insert columns in a protected worksheet.  
Public PropertyAllowInsertingHyperlinksReturns a boolean indicating if the user may insert hyperlinks in unlocked cells in a protected worksheet.  
Public PropertyAllowInsertingRowsReturns a boolean indicating if the user may insert rows in a protected worksheet.  
Public PropertyAllowSortingReturns a boolean indicating if the sorting is allowed in a protected worksheet.  
Public PropertyAllowUsingPivotTablesReturns a boolean indicating if the user can change pivot tables in a protected worksheet.  
Public PropertySelectionModeReturns or sets an enumeration used to indicate how cell selection should be affected when the associated Worksheet is protected.  
See Also

Reference

WorksheetProtection Class
Infragistics.Documents.Excel Namespace
Worksheet.HasProtectionPassword
Worksheet.IsProtected
Protection Property
Protect Method
Worksheet.Unprotect()