Hi Gurus,

I've an excel worksheet with sama data to be protected and some data to be updated by our users on a regular basis.

My query is, will it be possible to use VBA code to password protect any selected row after updating? Meaning, once the user has finished updating that particular row, maybe with a click of a button, that row will be procteted and no additional change allowed. Only admin who has the password will be able to make any additional changes.

However, the rest of the row will still be accessible and updated by user till it's protected.

Appreciate for your help.

Thanks.


- Jack