Excel.WorksheetProtectionOptions interface

Package:

excel

Represents the options in sheet protection.

Remarks

[ API set: ExcelApi 1.2 ]

Properties

allowAutoFilter	Represents the worksheet protection option allowing use of the AutoFilter feature.
allowDeleteColumns	Represents the worksheet protection option allowing deleting of columns.
allowDeleteRows	Represents the worksheet protection option allowing deleting of rows.
allowEditObjects	Represents the worksheet protection option allowing editing of objects.
allowEditScenarios	Represents the worksheet protection option allowing editing of scenarios.
allowFormatCells	Represents the worksheet protection option allowing formatting of cells.
allowFormatColumns	Represents the worksheet protection option allowing formatting of columns.
allowFormatRows	Represents the worksheet protection option allowing formatting of rows.
allowInsertColumns	Represents the worksheet protection option allowing inserting of columns.
allowInsertHyperlinks	Represents the worksheet protection option allowing inserting of hyperlinks.
allowInsertRows	Represents the worksheet protection option allowing inserting of rows.
allowPivotTables	Represents the worksheet protection option allowing use of the PivotTable feature.
allowSort	Represents the worksheet protection option allowing use of the sort feature.
selectionMode	Represents the worksheet protection option of selection mode.

Property Details

allowAutoFilter

Represents the worksheet protection option allowing use of the AutoFilter feature.

TypeScript

allowAutoFilter?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowDeleteColumns

Represents the worksheet protection option allowing deleting of columns.

TypeScript

allowDeleteColumns?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowDeleteRows

Represents the worksheet protection option allowing deleting of rows.

TypeScript

allowDeleteRows?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowEditObjects

Represents the worksheet protection option allowing editing of objects.

TypeScript

allowEditObjects?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

allowEditScenarios

Represents the worksheet protection option allowing editing of scenarios.

TypeScript

allowEditScenarios?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.7 ]

allowFormatCells

Represents the worksheet protection option allowing formatting of cells.

TypeScript

allowFormatCells?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowFormatColumns

Represents the worksheet protection option allowing formatting of columns.

TypeScript

allowFormatColumns?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowFormatRows

Represents the worksheet protection option allowing formatting of rows.

TypeScript

allowFormatRows?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowInsertColumns

Represents the worksheet protection option allowing inserting of columns.

TypeScript

allowInsertColumns?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowInsertHyperlinks

Represents the worksheet protection option allowing inserting of hyperlinks.

TypeScript

allowInsertHyperlinks?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowInsertRows

Represents the worksheet protection option allowing inserting of rows.

TypeScript

allowInsertRows?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowPivotTables

Represents the worksheet protection option allowing use of the PivotTable feature.

TypeScript

allowPivotTables?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

allowSort

Represents the worksheet protection option allowing use of the sort feature.

TypeScript

allowSort?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

selectionMode

Represents the worksheet protection option of selection mode.

TypeScript

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

Property Value

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

Remarks

[ API set: ExcelApi 1.7 ]