Dear Friends,

I need to disable one or more cells, so that the user can not enter any data
in those field(s), when the respective cell's value meets some condition.

For example, if the column heading is say "Pending Job" and its entries will
be either "Pending" or "Completed". This will be selected by the user in the
form of List, so he can't enter anything other than these two. Once he
selected the cell's value as "Completed", then that particular cell should be
Disabled, so that in future he can't change it again to "Pending".

Kindly help me how to achieve this by means of Macro codings, because I amde
the whole file's data and its results are controlled by Macro codings.

Kindly help me ASAP.

Thanks and Regards,
Sriram S