I would think you would need a Worksheet_Change macro running all the
time protecting and unprotecting the sheet as you make changes. As you
exit a cell, the macro would unprotect the sheet, check to see if the
cell you WERE in has a value greater than blank or 0, and if so, setting
the protection value for that cell, then reprotecting the sheet.

Your protected sheet could only let you select unlocked cells, so as
your cursor moves around, it would only rest in empty cells.


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=48899