Patrick

Excel has no way of knowing when you have completed data entry in a cell without
some sort of trigger like Tab, ENTER or Arrow key to move out of the cell.

No code can run while you are in Edit mode so VBA is out.


Gord Dibben MS Excel MVP

On Mon, 2 Apr 2007 13:20:00 -0700, Patrick Riley
wrote:

I have a protected worksheet. I enter a single digit of data into
unprotected cells. I want the cursor to automatically move to the next
unprotected cell after I input the single digit, without the need to use the
TAB or ENTER key.
Does anyone have a solution?
Patrick Riley