AllowEditRange.Unprotect Method
| Excel Developer Reference |
Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.
Syntax
expression.Unprotect(Password)
expression A variable that represents an AllowEditRange object.
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| Password | Optional | Variant | A string that denotes the case-sensitive password to use to unprotect the range of cells. If the range isn't protected with a password, this argument is ignored. |
Remarks
If you forget the password, you cannot unprotect the sheet or workbook. It's a good idea to keep a list of your passwords and their corresponding document names in a safe place.
See Also