Workbook.Unprotect Method

Removes protection from the workbook. This method has no effect if the workbook is not protected.

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

Syntax

'Declaration
Sub Unprotect ( _
    Password As Object _
)
void Unprotect(
    Object Password
)

Parameters

  • Password
    Type: System.Object
    The case-sensitive password to use to unprotect the workbook. If the workbook is not protected with a password, this parameter is ignored. If you omit this parameter for a workbook that is protected with a password, the method fails.

Remarks

If you forget the password, you cannot unprotect the workbook. It is a good idea to keep a list of your passwords and their corresponding document names in a safe place.

Optional Parameters

For information on optional parameters, see Optional Parameters in Office Solutions.

.NET Framework Security

See Also

Reference

Workbook Interface

Microsoft.Office.Tools.Excel Namespace