WorksheetBase.Unprotect(Object) Method
Definition
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 worksheet. This method has no effect if the worksheet is not protected.
public void Unprotect (object password);member this.Unprotect : obj -> unitPublic Sub Unprotect (Optional password As Object)Parameters
- password
- Object
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.
Examples
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.
This example is for a document-level customization.
private void PromptUnprotectWorksheet()
{
if (this.ProtectContents)
{
if (DialogResult.Yes == MessageBox.Show("The worksheet is protected. " +
"Unprotect the worksheet?", "Example",
MessageBoxButtons.YesNo))
{
this.Unprotect();
}
}
}
Private Sub PromptUnprotectWorksheet()
If Me.ProtectContents Then
If DialogResult.Yes = MessageBox.Show("The worksheet is protected. " & _
"Unprotect the worksheet?", "Example", MessageBoxButtons.YesNo) Then
Me.Unprotect()
End If
End If
End Sub
Remarks
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 Optional Parameters in Office Solutions.