WorkbookBase.Unprotect(Object) Method

Reference

Definition

Namespace:: Microsoft.Office.Tools.Excel

Assembly:: Microsoft.Office.Tools.Excel.v4.0.Utilities.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

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

public void Unprotect (object password);

member this.Unprotect : obj -> unit

Public Sub Unprotect (Optional password As Object)

Parameters

password: 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.

Examples

The following code example uses the Protect method to protect the structure of the workbook and workbook windows, but without specifying password protection. The example then prompts the user to unprotect the workbook by using the Unprotect method.

This example is for a document-level customization.

private void WorkbookUnprotect()
{
    MessageBox.Show("Protecting the workbook.");
    this.Protect( true, true);

    if (DialogResult.Yes == MessageBox.Show("Unprotect the workbook?",
        "Custom Unprotect Dialog", MessageBoxButtons.YesNo))
    {
        this.Unprotect();
    }
}

Private Sub WorkbookUnprotect()
    MsgBox("Protecting the workbook.")
    Me.Protect(structure:=True, windows:=True)

    If DialogResult.Yes = MessageBox.Show( _
        "Unprotect the workbook?", "Custom Unprotect Dialog", _
        MessageBoxButtons.YesNo) Then
        Me.Unprotect()
    End If
End Sub

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.

Applies to

Compartilhar via