I am using a checkbox (forms not activeX). The checkbox is linked to cell A1, so A1 is True when the checkbox is checked and false when the checkbox is not checked.

I want the sheet to be locked/protected when A1 is TRUE and when A1 is false have the sheet unlocked/unprotected.

Any suggestions on how to achieve this?