AllowEditRange.Unprotect Method (Excel)

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.

See also

AllowEditRange Object