See my response to thread entitled VBA by Olen in the programming group.

--
HTH

Bob Phillips

"Triangle" wrote in message
...
I need to be able to stop an entry being completed in a cell unless an
entry
in another has been completed. (eg, a COMMENT cell can only be completed
after the INITIALS cell has been completed)