Hey folks,
I have the following checkbox on a sheet that is protected but users have the ability to do the following:
- Select locked cells
- Select unlocked cells
I then have the following code associated to a checkbox:
I have a couple of concerns:
- The Protect and Unprotect that I have put in place for the "On" case seems very redundant - is there a better way of doing this?
- On the "Off" case I keep getting a Read-Only Error on the range "Range("Zone1_SongInterval_Warning").ClearContents" and I can't figure out why that is the case when I have Unprotected the sheet at the beginning of the "Off" case.
Any help would be greatly appreciated.
Bookmarks