Workbook.UnprotectSharing Method

Excel Developer Reference

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.

Visual Basic for Applications
  ActiveWorkbook.UnprotectSharing

See Also