I have a cell with data validation rules set. When an invalid entry is typed
in and the Enter key pressed, the rules work fine and reject the entry.
However, if an invalid entry is typed in and the another cell is selected
with the mouse (without pressing Enter), the invalid data is accepted in the
cell. Is there any way of stopping this ?
Thanks
Simon