MISSYKIMVO
New Member
- Joined
- Dec 9, 2017
- Messages
- 2
Hello,
I'm trying to create a worksheet_change macro in where if there is an "x" in column k cells n:ae in that row would lock. All the data is currently in a table so I don't want to have to put in a valued range ie: k1:k9 but the table starts at row 9 and then changes per worksheet but the rules are always the same. IF an x is entered the corresponding columns n:ae would lock.
Any help is appreciated!!!
Thanks!!
I'm trying to create a worksheet_change macro in where if there is an "x" in column k cells n:ae in that row would lock. All the data is currently in a table so I don't want to have to put in a valued range ie: k1:k9 but the table starts at row 9 and then changes per worksheet but the rules are always the same. IF an x is entered the corresponding columns n:ae would lock.
Any help is appreciated!!!
Thanks!!