Version

WorksheetProtection Class Members

The following tables list the members exposed by WorksheetProtection.

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