Locking individual rows for a value in one cell

In my worksheet for cells I7:R56 I want for any value entered in a cell to lock the rest of the cells of that same row to be locked. e.g. if I have entered a value in I7, I want J7:R7 to be locked automatically.

How can I do this? 

By: Masud

Leave a Reply

Your email address will not be published. Required fields are marked *