I have a cell E21 that by default is locked. Using a worksheet_change E21 can be unlocked based on E20="override". I also have a reset script that will change all entries back to default (ie E20="orange"). What I'm having a difficult time of is locking E21 if it was unlocked and leaving it alone if it's already locked.

in a nut shell -

if e21 = locked then do nothing
if e21 = unlocked then lock

Can someone please help convert my above gibberish into VBA?

Thank you.