_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.ObjectOptional 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.