Excel.Workbook.UnprotectSharing.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.UnprotectSharing method (Excel)	vbaxl10.chm199158	vbaxl10.chm199158	Excel.Workbook.UnprotectSharing	edce1744-0906-4b4e-8b98-5d1125047bff	05/29/2019	medium

Workbook.UnprotectSharing method (Excel)

Turns off protection for sharing and saves the workbook.

Syntax

expression.UnprotectSharing (SharingPassword)

expression A variable that represents a Workbook object.

Parameters

Name	Required/Optional	Data type	Description
SharingPassword	Optional	Variant	The workbook password.

Example

This example turns off protection for sharing and saves the active workbook.

ActiveWorkbook.UnprotectSharing

[!includeSupport and feedback]