On Feb 10, 9:33*pm, "Peter T" <peter_t@discussions wrote:
wrote in message news:a4b65605-3617-4fbc-9116-
Thanks for your help. *Editing is not allowed if someone makes
a mistake, he/she should contact the admin for help.

OK, so the code I suggested should work for your purposes. Maybe start by
only "unlocking" cells user can enter data once only. Did you try the
sugegstion.

Can it prop up a message box saying to contact the
admin for the password/help?

Probably, but in what scenario, your question is not clear.

RegardsRashidKhan

Sorry my system was down.
Actually the solution you provided works but mine is a shared workbook
and it does not work with shared workbook
However, if a msg box can prop up when the user tries to edit the
cell.

Thanks

Rashid Khan