lock row when specific cells have data added.

Morning happy campers.

My spreadsheet goes from Column A over to S,
I am looking for some code that will do the following:

Lock all rows containing data to prevent editing / changes , (where data is present in Column K1, 2, 3, 4, 5, 6 & 7 for example, lock rows 1-7)
*based on the following criteria
When a user saves and/or closes the sheet.

BUT - i would like to be able to easily modify the code, lets say that today my requirement is to lock the rows based on column K containing data, but next week it may be a different column, B for example.

I already have some code i can modify to allow the protection to be removed based on the user ID in windows, but am struggling to make the above work.

I did have some code before that would lock cells based on the cell 'Changing' but i found that even double clicking in the cell would cause it to lock, so i would need this one to look at the cell being blank or not instead of the 'change' being the trigger.

Many thanks in advance

Galvinpaddy

Hi Galvin,

I did have some code before that would lock cells based on the cell 'Changing' but i found that even double clicking in the cell would cause it to lock, so i would need this one to look at the cell being blank or not instead of the 'change' being the trigger.

I still think this would be the best way to go, just check if the cell is empty.
Do like this :

Please Login or Register  to view this content.

Please click the * below if this helps