Error 1004: Unable to set the Locked property of the Range class

Dear Experts:

Hope this post finds you well!

I'm trying to lock an entire Worksheet except for some cells depending on the content of a specific cell on another sheet.

This lock/unlock is evaluated when the sheet to be locked (Context) is activated.

Please Login or Register  to view this content.

The range to be locked/unlocked includes merged cells and single cells. Initially, the sheet is locked with the password "123" and allows editing only on the range indicated.

The thing is that I'm getting this error:

Error.png
Debug.png

Could you please advice?

Thanks in advance! Have a great day!

That implies that the sheet has not been unprotected. Try unprotecting it manually and resetting the passsword.