I am creating a form in Excel and need some help.

I would like to lock cells depending on whether a check box is true or false. I wrote some code that accomplishes this, but when I protect the sheet, I get an error because the sheet is protected.

In essence, I only want a user to be able to enter data if a check box is true. If the check box is false, I want the cells to be locked.

I hope I explained that right.

Please Help.

Ross