_Workbook.UnprotectSharing Method

Turns off protection for sharing and saves the workbook.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub UnprotectSharing ( _
    SharingPassword As Object _
)
'Usage
Dim instance As _Workbook
Dim SharingPassword As Object

instance.UnprotectSharing(SharingPassword)
void UnprotectSharing(
    Object SharingPassword
)

Parameters

  • SharingPassword
    Type: System.Object

    Optional Object. The workbook password.

Remarks

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.

See Also

Reference

_Workbook Interface

_Workbook Members

Microsoft.Office.Interop.Excel Namespace