Lock and protect selected excel rows with VBA code

Hi Gurus,

Thanks for the reply.

I've tried your solution, but there are some issues.

Users are only allowed to update the yellow highlighted area only.

I've tried to lock outside yellow area with protection, but when I click on the button, it removes them.

Also, I hit with an error when trying to update raw 7, see attached (SampleData-Test2.xls).

The code should be able to cater the ongoing update within the yellow area.

Appreciate for your help.

Thank you.


- Jack