Lock/unlock cell range based on cell value

I want to lock/unlock a range of cells (10-76) based on the value of cell 8

I've figured out how to lock/unlock one column of cells based on the value of a specific target cell using the following formula:

Please Login or Register  to view this content.

But what I'm having difficulty with is figuring out how to apply this to the rest of my columns (F-P) so that if E8="Actuals" the cells in that column will unlock and if F8="Actuals" the cells in that column will unlock, and so on.

Thanks in advance!

Nope, that didn't work. I'm thinking it might be something close to my original code, but possibly using mycell.column?

Oh, well 2 points of clarification:

1) I used the Calculate function because cells E8-P8 will change based on a formula triggered by another cell (no manual entry).
2) Your code seems to be unlocking all the cells in the range (E10-P76) based on the value of E8. What I want to do is only unlock those cells in the corresponding column. So if E8=Actuals, it'll unlock E10-E76, and if F8=Actuals it'll unlock F10-F76, and so on.

Does that make sense?

Yes, this should help illustrate what I'm trying to do.

You can just unlock, there is no password.

That seemed to do the trick. Thanks so much for your help!

There are probably more elegant ways to do it, but I also figured out a way to achieve the same result based on a calculated cell.

Please Login or Register  to view this content.