Locking the current row for edit when the value in a cell changes

[Melfyn]

I tried almost all the macros/Examples given in this forum . Sadly nothing works.

My Problem:

I have a sheet with values from A to L. If the value in the cell "L1" changes to "Approve" then the particular row alone should locked.
If the second row has the value for the cell "L2" is "Reject". Then no need to lock that row.

Any help will be much appreciated.

[Richard Buttrey]

For cells to be locked sheet protection needs to be ON, and by default if it's ON then all cells are locked.
So first select all cells and unlock them - Format..Cells..Protection and untick the 'Locked' option.

Now use the following Sheet Change procedure

Please Login or Register  to view this content.

[Melfyn]

Thank you very much Richard. It works .......