excel.worksheetprotectionoptions.yml

### YamlMime:TSType
name: Excel.WorksheetProtectionOptions
uid: 'excel!Excel.WorksheetProtectionOptions:interface'
package: excel!
fullName: Excel.WorksheetProtectionOptions
summary: Represents the options in sheet protection.
remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
isPreview: false
isDeprecated: false
type: interface
properties:
  - name: allowAutoFilter
    uid: 'excel!Excel.WorksheetProtectionOptions#allowAutoFilter:member'
    package: excel!
    fullName: allowAutoFilter
    summary: Represents the worksheet protection option allowing use of the AutoFilter feature.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowAutoFilter?: boolean;'
      return:
        type: boolean
  - name: allowDeleteColumns
    uid: 'excel!Excel.WorksheetProtectionOptions#allowDeleteColumns:member'
    package: excel!
    fullName: allowDeleteColumns
    summary: Represents the worksheet protection option allowing deleting of columns.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowDeleteColumns?: boolean;'
      return:
        type: boolean
  - name: allowDeleteRows
    uid: 'excel!Excel.WorksheetProtectionOptions#allowDeleteRows:member'
    package: excel!
    fullName: allowDeleteRows
    summary: Represents the worksheet protection option allowing deleting of rows.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowDeleteRows?: boolean;'
      return:
        type: boolean
  - name: allowFormatCells
    uid: 'excel!Excel.WorksheetProtectionOptions#allowFormatCells:member'
    package: excel!
    fullName: allowFormatCells
    summary: Represents the worksheet protection option allowing formatting of cells.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowFormatCells?: boolean;'
      return:
        type: boolean
  - name: allowFormatColumns
    uid: 'excel!Excel.WorksheetProtectionOptions#allowFormatColumns:member'
    package: excel!
    fullName: allowFormatColumns
    summary: Represents the worksheet protection option allowing formatting of columns.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowFormatColumns?: boolean;'
      return:
        type: boolean
  - name: allowFormatRows
    uid: 'excel!Excel.WorksheetProtectionOptions#allowFormatRows:member'
    package: excel!
    fullName: allowFormatRows
    summary: Represents the worksheet protection option allowing formatting of rows.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowFormatRows?: boolean;'
      return:
        type: boolean
  - name: allowInsertColumns
    uid: 'excel!Excel.WorksheetProtectionOptions#allowInsertColumns:member'
    package: excel!
    fullName: allowInsertColumns
    summary: Represents the worksheet protection option allowing inserting of columns.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowInsertColumns?: boolean;'
      return:
        type: boolean
  - name: allowInsertHyperlinks
    uid: 'excel!Excel.WorksheetProtectionOptions#allowInsertHyperlinks:member'
    package: excel!
    fullName: allowInsertHyperlinks
    summary: Represents the worksheet protection option allowing inserting of hyperlinks.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowInsertHyperlinks?: boolean;'
      return:
        type: boolean
  - name: allowInsertRows
    uid: 'excel!Excel.WorksheetProtectionOptions#allowInsertRows:member'
    package: excel!
    fullName: allowInsertRows
    summary: Represents the worksheet protection option allowing inserting of rows.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowInsertRows?: boolean;'
      return:
        type: boolean
  - name: allowPivotTables
    uid: 'excel!Excel.WorksheetProtectionOptions#allowPivotTables:member'
    package: excel!
    fullName: allowPivotTables
    summary: Represents the worksheet protection option allowing use of the PivotTable feature.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowPivotTables?: boolean;'
      return:
        type: boolean
  - name: allowSort
    uid: 'excel!Excel.WorksheetProtectionOptions#allowSort:member'
    package: excel!
    fullName: allowSort
    summary: Represents the worksheet protection option allowing use of the sort feature.
    remarks: '\[ [API set: ExcelApi 1.2](/javascript/api/requirement-sets/excel/excel-api-requirement-sets) \]'
    isPreview: false
    isDeprecated: false
    syntax:
      content: 'allowSort?: boolean;'
      return:
        type: boolean