Lock cell after first edit on shared workbook

[nianchi111]

Dear Friends,

I do have an excel tracker where 5 users are using it.

Challenges I face is, when a person enters a comment in Column C they are changing the Comments once they feel that is incorrect.

So in Column C, when a person makes any changes that particular cell needs to be locked/protected.

This is a Shared workbook.

Please help me...

 

[Smitty]

Unfortunately programmatic locking/protection/unprotection isn't supported in shared workbooks, so I'm not sure of a suitable workaround.