Unlock columns M:T when cell E has "LOP" or "XOP" or "WOP"

[Frigide]

I want to unlock columns M til T (M:T) when cel E has "LOP" or "XOP" or "WOP".

This code work but does not does it all!

Please Login or Register  to view this content.

But this is not

Please Login or Register  to view this content.

How to get 3 criteria to unlock en then unlock the range M:T

[6StringJazzer]

Please Login or Register  to view this content.

Boolean expression syntax doesn't work like that. You have to do this:

Please Login or Register  to view this content.

[Frigide]

Thanks. Never used or before. Stupid me used and like this and didn't realized it.
The shJ.Range("M:T" & y).Locked = False is not working ether.

[protonLeah]

Then shJ.Range("M:T" & y).Locked ---> error!

Please Login or Register  to view this content.

[Frigide]

That is it! The or i should have known. But the .Resize(columnsize:=8) is complete new for me. So i learned something today!!

Tanks to you both

[protonLeah]

welcome