Hi

I have a bit of a quandary. I would like to know if it is possible to lock
cells once the Enter / Return Key has been pressed or the cursor has been
moved from the cell. I don't care if it is Macro or VBA as long as the cell
can be locked.

A simple example would be were you enter data in say cell C5, press Enter. I
would like to lock that cell from being edited with the exception of
Administrators.

Many thanks in advance for any help I get

Peter (UK)