| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
AllowEditRange.Unprotect method (Excel) |
vbaxl10.chm725077 |
|
|
3c7679c6-828d-e1c4-7009-f42bad1a66d6 |
04/04/2019 |
medium |
Removes protection from a sheet or workbook. This method has no effect if the sheet or workbook isn't protected.
expression.Unprotect (Password)
expression A variable that represents an AllowEditRange object.
| 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. |
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.
[!includeSupport and feedback]