Excel.WorksheetProtectionOptions interface

Represents the options in sheet protection.

[ API set: ExcelApi 1.2 ]

Properties

allowAutoFilter

Represents the worksheet protection option of allowing using auto filter feature.

[ API set: ExcelApi 1.2 ]

allowDeleteColumns

Represents the worksheet protection option of allowing deleting columns.

[ API set: ExcelApi 1.2 ]

allowDeleteRows

Represents the worksheet protection option of allowing deleting rows.

[ API set: ExcelApi 1.2 ]

allowEditObjects

Represents the worksheet protection option of allowing editing objects.

[ API set: ExcelApi 1.7 ]

allowEditScenarios

Represents the worksheet protection option of allowing editing scenarios.

[ API set: ExcelApi 1.7 ]

allowFormatCells

Represents the worksheet protection option of allowing formatting cells.

[ API set: ExcelApi 1.2 ]

allowFormatColumns

Represents the worksheet protection option of allowing formatting columns.

[ API set: ExcelApi 1.2 ]

allowFormatRows

Represents the worksheet protection option of allowing formatting rows.

[ API set: ExcelApi 1.2 ]

allowInsertColumns

Represents the worksheet protection option of allowing inserting columns.

[ API set: ExcelApi 1.2 ]

allowInsertHyperlinks

Represents the worksheet protection option of allowing inserting hyperlinks.

[ API set: ExcelApi 1.2 ]

allowInsertRows

Represents the worksheet protection option of allowing inserting rows.

[ API set: ExcelApi 1.2 ]

allowPivotTables

Represents the worksheet protection option of allowing using PivotTable feature.

[ API set: ExcelApi 1.2 ]

allowSort

Represents the worksheet protection option of allowing using sort feature.

[ API set: ExcelApi 1.2 ]

selectionMode

Represents the worksheet protection option of selection mode.

[ API set: ExcelApi 1.7 ]

Property Details

allowAutoFilter

Represents the worksheet protection option of allowing using auto filter feature.

[ API set: ExcelApi 1.2 ]

allowAutoFilter?: boolean;

Property Value

boolean

allowDeleteColumns

Represents the worksheet protection option of allowing deleting columns.

[ API set: ExcelApi 1.2 ]

allowDeleteColumns?: boolean;

Property Value

boolean

allowDeleteRows

Represents the worksheet protection option of allowing deleting rows.

[ API set: ExcelApi 1.2 ]

allowDeleteRows?: boolean;

Property Value

boolean

allowEditObjects

Represents the worksheet protection option of allowing editing objects.

[ API set: ExcelApi 1.7 ]

allowEditObjects?: boolean;

Property Value

boolean

allowEditScenarios

Represents the worksheet protection option of allowing editing scenarios.

[ API set: ExcelApi 1.7 ]

allowEditScenarios?: boolean;

Property Value

boolean

allowFormatCells

Represents the worksheet protection option of allowing formatting cells.

[ API set: ExcelApi 1.2 ]

allowFormatCells?: boolean;

Property Value

boolean

allowFormatColumns

Represents the worksheet protection option of allowing formatting columns.

[ API set: ExcelApi 1.2 ]

allowFormatColumns?: boolean;

Property Value

boolean

allowFormatRows

Represents the worksheet protection option of allowing formatting rows.

[ API set: ExcelApi 1.2 ]

allowFormatRows?: boolean;

Property Value

boolean

allowInsertColumns

Represents the worksheet protection option of allowing inserting columns.

[ API set: ExcelApi 1.2 ]

allowInsertColumns?: boolean;

Property Value

boolean

Represents the worksheet protection option of allowing inserting hyperlinks.

[ API set: ExcelApi 1.2 ]

allowInsertHyperlinks?: boolean;

Property Value

boolean

allowInsertRows

Represents the worksheet protection option of allowing inserting rows.

[ API set: ExcelApi 1.2 ]

allowInsertRows?: boolean;

Property Value

boolean

allowPivotTables

Represents the worksheet protection option of allowing using PivotTable feature.

[ API set: ExcelApi 1.2 ]

allowPivotTables?: boolean;

Property Value

boolean

allowSort

Represents the worksheet protection option of allowing using sort feature.

[ API set: ExcelApi 1.2 ]

allowSort?: boolean;

Property Value

boolean

selectionMode

Represents the worksheet protection option of selection mode.

[ API set: ExcelApi 1.7 ]

selectionMode?: Excel.ProtectionSelectionMode | "Normal" | "Unlocked" | "None";

Property Value

Excel.ProtectionSelectionMode | "Normal" | "Unlocked" | "None"