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