Unprotect-OfficeExcelSheet.md

external help file	Module Name	online version	schema
PSWriteOffice-help.xml	PSWriteOffice	https://github.com/EvotecIT/PSWriteOffice	2.0.0

Unprotect-OfficeExcelSheet

SYNOPSIS

Removes worksheet protection.

SYNTAX

Context (Default)

Unprotect-OfficeExcelSheet [-PassThru] [<CommonParameters>]

Document

Unprotect-OfficeExcelSheet -Document <ExcelDocument> [-Sheet <string>] [-SheetIndex <int>] [-PassThru] [<CommonParameters>]

DESCRIPTION

Removes worksheet protection.

EXAMPLES

EXAMPLE 1

PS>ExcelSheet 'Data' { Unprotect-OfficeExcelSheet }

Removes worksheet protection.

PARAMETERS

-Document

Workbook to operate on outside the DSL context.

Type: ExcelDocument
Parameter Sets: Document
Aliases: None
Possible values: 

Required: True
Position: named
Default value: None
Accept pipeline input: True (ByValue)
Accept wildcard characters: True

-PassThru

Emit the worksheet after removing protection.

Type: SwitchParameter
Parameter Sets: Context, Document
Aliases: None
Possible values: 

Required: False
Position: named
Default value: None
Accept pipeline input: False
Accept wildcard characters: True

-Sheet

Worksheet name when using Document.

Type: String
Parameter Sets: Document
Aliases: None
Possible values: 

Required: False
Position: named
Default value: None
Accept pipeline input: False
Accept wildcard characters: True

-SheetIndex

Worksheet index (0-based) when using Document.

Type: Nullable`1
Parameter Sets: Document
Aliases: None
Possible values: 

Required: False
Position: named
Default value: None
Accept pipeline input: False
Accept wildcard characters: True

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutVariable, -OutBuffer, -PipelineVariable, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

INPUTS

• OfficeIMO.Excel.ExcelDocument

OUTPUTS

• System.Object

RELATED LINKS

• None