Gary,

I have been working with Neil on this issue. Thanks a lot for supplying the
code below. However, we do not seem to be able to get it to work. When you
enter a value in cell b, you can still edit cell a. As Neil explained
previoisly we need the code to lock the cell to its right when a value is
entered into it.

Also, the sheet is question it protected already as we do not want cetain
cells to be edited. Will this affect the code in anyway?

--
Duncan


"Neil" wrote:

I would like to protect cells once a value has been placed in another cell.
E.G. I have a sign off date column and once a value has been entered I want
the cells to the left to be protected. Is this Possible?