By the way, I'm on the East Coast of the US so I think I'm about 5 hours
behind you.
--
Gary Brown

If this post was helpful, please click the ''''Yes'''' button next to
''''Was this Post Helpfull to you?".


"Duncan" wrote:

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?