Provides information about the types of changes that are disabled when the associated Worksheet is protected.
Inheritance
Properties
Section titled "Properties"AllowDeletingColumns
Section titled "AllowDeletingColumns"Returns a boolean indicating if the deletion of columns is allowed in a protected worksheet.
public bool AllowDeletingColumns { get; } AllowDeletingRows
Section titled "AllowDeletingRows"Returns a boolean indicating if the deletion of rows is allowed in a protected worksheet.
public bool AllowDeletingRows { get; } AllowEditObjects
Section titled "AllowEditObjects"Returns a boolean indicating if objects such as shapes, comments, charts and controls may be created or changed when the worksheet is protected.
public bool AllowEditObjects { get; } AllowEditScenarios
Section titled "AllowEditScenarios"Returns a boolean indicating if existing scenarios are protected when the worksheet is protected.
public bool AllowEditScenarios { get; } AllowFiltering
Section titled "AllowFiltering"Returns a boolean indicating if the user may use an auto filter created before the worksheet was protected.
public bool AllowFiltering { get; } AllowFormattingCells
Section titled "AllowFormattingCells"Returns a boolean indicating if the user may change the formatting of cells in a protected worksheet.
public bool AllowFormattingCells { get; } AllowFormattingColumns
Section titled "AllowFormattingColumns"Returns a boolean indicating if the user may change column information such as its width or visibility in a protected worksheet.
public bool AllowFormattingColumns { get; } AllowFormattingRows
Section titled "AllowFormattingRows"Returns a boolean indicating if the user may change row information such as its height or visibility in a protected worksheet.
public bool AllowFormattingRows { get; } AllowInsertingColumns
Section titled "AllowInsertingColumns"Returns a boolean indicating if the user may insert columns in a protected worksheet.
public bool AllowInsertingColumns { get; } AllowInsertingHyperlinks
Section titled "AllowInsertingHyperlinks"Returns a boolean indicating if the user may insert hyperlinks in unlocked cells in a protected worksheet.
public bool AllowInsertingHyperlinks { get; } AllowInsertingRows
Section titled "AllowInsertingRows"Returns a boolean indicating if the user may insert rows in a protected worksheet.
public bool AllowInsertingRows { get; } AllowSorting
Section titled "AllowSorting"Returns a boolean indicating if the sorting is allowed in a protected worksheet.
public bool AllowSorting { get; } AllowUsingPivotTables
Section titled "AllowUsingPivotTables"Returns a boolean indicating if the user can change pivot tables in a protected worksheet.
public bool AllowUsingPivotTables { get; } AllowedEditRanges
Section titled "AllowedEditRanges"Returns a collection of instances that define which locked ranges of cells may be edited in a protected worksheet.
public WorksheetProtectedRangeCollection AllowedEditRanges { get; } SelectionMode
Section titled "SelectionMode"Returns or sets an enumeration used to indicate how cell selection should be affected when the associated Worksheet is protected.
public WorksheetProtectedSelectionMode SelectionMode { get; set; }