Hello:
I have lots of data in excel sheet.
I want to lock the cell row Range A:K for if L=TRUE.
Basically when I enter TRUE in cell L5, then it needs to lock cell A5:K5 immediately.
Example :
Row 2 : If L2 = TRUE then lock Cell A2:K2.
Row 9 : If L9 = TRUE then lock cell A9:K9.
I need this to perform the whole sheet.
To unlock any row, would need password : 1234
Please help and let me know if any question.
Riz
Bookmarks