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.

allowAutoFilter?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

allowDeleteColumns

Represents the worksheet protection option allowing deleting of columns.

allowDeleteColumns?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

allowDeleteRows

Represents the worksheet protection option allowing deleting of rows.

allowDeleteRows?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

allowEditObjects

Represents the worksheet protection option allowing editing of objects.

allowEditObjects?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.7]

allowEditScenarios

Represents the worksheet protection option allowing editing of scenarios.

allowEditScenarios?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.7]

allowFormatCells

Represents the worksheet protection option allowing formatting of cells.

allowFormatCells?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

allowFormatColumns

Represents the worksheet protection option allowing formatting of columns.

allowFormatColumns?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

allowFormatRows

Represents the worksheet protection option allowing formatting of rows.

allowFormatRows?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

allowInsertColumns

Represents the worksheet protection option allowing inserting of columns.

allowInsertColumns?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

allowInsertHyperlinks

Represents the worksheet protection option allowing inserting of hyperlinks.

allowInsertHyperlinks?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

allowInsertRows

Represents the worksheet protection option allowing inserting of rows.

allowInsertRows?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

allowPivotTables

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

allowPivotTables?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

allowSort

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

allowSort?: boolean;

Property Value

boolean

Remarks

[Api set: ExcelApi 1.2]

selectionMode

Represents the worksheet protection option of selection mode.

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

Property Value

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

Remarks

[Api set: ExcelApi 1.7]