Export (0) Print
Expand All
0 out of 7 rated this helpful - Rate this topic

Worksheet.Unprotect Method

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

Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel (in microsoft.office.tools.excel.dll)

public virtual void Unprotect (
	[OptionalAttribute] Object Password
)

Parameters

Password

The case-sensitive password to use to unprotect the worksheet. If the worksheet is not protected with a password, this argument is ignored. If you omit this argument for a worksheet that is protected with a password, you will be prompted for the password.

If you forget the password, you cannot unprotect the worksheet. 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 Understanding Optional Parameters in COM Interop.

The following code example determines whether the cell contents of the current worksheet are protected. If the cell contents are protected, then the example prompts the user to unprotect the cell contents by using the Unprotect method.

private void PromptUnprotectWorksheet()
{
    if (this.ProtectContents)
    {
        if (DialogResult.Yes == MessageBox.Show("The worksheet is protected. " +
            "Unprotect the worksheet?", "Example",
            MessageBoxButtons.YesNo))
        {
            this.Unprotect(missing);
        }
    }
}

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.