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