-
Solved: Protect/Unprotect Cells with VBA
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules