Worksheet.Unprotect Method (Object)


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)

void Unprotect(
	object Password


Type: System.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.

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.

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

Return to top