Lock and protect selected excel rows with VBA code

Hi Holger,

Thanks for your help.

I've tried, but it locked all the rows, including those raws which have not been updated.

I've attached my test data, I'm unable to update row 7 onwards.

Please advice. Thanks.


- Jack