UnprotectSharing Method [Excel 2003 VBA Language Reference]

Turns off protection for sharing and saves the workbook.

expression**.UnprotectSharing(SharingPassword)**

expression Required. An expression that returns a Workbook object.

SharingPassword   Optional Variant. The workbook password.

Note  Use strong passwords that combine upper- and lowercase letters, numbers, and symbols. Weak passwords don't mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you don't have to write it down.

Example

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

ActiveWorkbook.UnprotectSharing

Applies to | Workbook Object