Provides information about the types of changes that are disabled when the associated Worksheet is protected.

Returns a boolean indicating if the deletion of columns is allowed in a protected worksheet.

public bool AllowDeletingColumns { get; }

Returns a boolean indicating if the deletion of rows is allowed in a protected worksheet.

public bool AllowDeletingRows { get; }

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; }

Returns a boolean indicating if existing scenarios are protected when the worksheet is protected.

public bool AllowEditScenarios { get; }

Returns a boolean indicating if the user may use an auto filter created before the worksheet was protected.

public bool AllowFiltering { get; }

Returns a boolean indicating if the user may change the formatting of cells in a protected worksheet.

public bool AllowFormattingCells { get; }

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; }

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; }

Returns a boolean indicating if the user may insert columns in a protected worksheet.

public bool AllowInsertingColumns { get; }

Returns a boolean indicating if the user may insert hyperlinks in unlocked cells in a protected worksheet.

public bool AllowInsertingHyperlinks { get; }

Returns a boolean indicating if the user may insert rows in a protected worksheet.

public bool AllowInsertingRows { get; }

Returns a boolean indicating if the sorting is allowed in a protected worksheet.

public bool AllowSorting { get; }

Returns a boolean indicating if the user can change pivot tables in a protected worksheet.

public bool AllowUsingPivotTables { get; }

Returns a collection of instances that define which locked ranges of cells may be edited in a protected worksheet.

public WorksheetProtectedRangeCollection AllowedEditRanges { get; }

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; }