Workbook.UnprotectSharing Method (2007 System)

Turns off protection for sharing and saves the workbook.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v9.0 (in Microsoft.Office.Tools.Excel.v9.0.dll)

Syntax

'Declaration
Public Sub UnprotectSharing ( _
    SharingPassword As Object _
)

'Usage
Dim instance As Workbook 
Dim SharingPassword As Object

instance.UnprotectSharing(SharingPassword)

public void UnprotectSharing(
    Object SharingPassword
)

public:
void UnprotectSharing(
    Object^ SharingPassword
)

public function UnprotectSharing(
    SharingPassword : Object
)

Parameters

• SharingPassword
  Type: System.Object

  The workbook password.

Remarks

Use strong passwords that combine uppercase and lowercase letters, numbers, and symbols. Weak passwords do not mix these elements. Strong password: Y6dh!et5. Weak password: House27. Use a strong password that you can remember so that you do not have to write it down.

Optional Parameters

For information on optional parameters, see The Variable missing and Optional Parameters in Office Solutions.

.NET Framework Security

• Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.

See Also

Reference

Workbook Class

Workbook Members

Microsoft.Office.Tools.Excel Namespace