Locking a Range of Cells Based on Other Cell Values

I have a worksheet that I want to have different ranges of cells locked, based on a different cells value. What I have right now is something that just locks an individual cell. I can't seem to figure out how to adjust the code to make it work for a range. It is probably very easy, but I cant figure it out. I have a few other ranges that I would want to apply this to, instead of adding the current code I have to each individual cell. But if I could have someone adjust my code for this range, I could adjust it for the others.

Please Login or Register  to view this content.

The cell that it should be referencing is B6 and the range of cells I want the code to apply to is A24:B27.

Thanks in advance!!

Yes! That is perfect! The only thing I changed was where you had ">2" i changed it to "<2"

I am going to add this code for all the different ranges I have. If I have any more questions about the code, I will let you know!!

Thanks again pike!

Is there a way to make a check box also work with cells being locked? Like if a checkbox is checked, it unlocks a couple other cells? I have checkboxes that if any one of them is checked, the user can move on to the next question. How can I make the following questions unlock and when they are locked, they should be gray?

nvm i think i got it.