PDA

View Full Version : [SOLVED] Skip if cell is filled - tab to next blank cell



Dale Bennett
10-21-2004, 05:35 PM
To make data entry easier and more accurate, is there a routine that will allow the user to tab to only blank cells within a range. Just locking certain cells is inadequate because you still "land" on locked cells.

Jacob Hilderbrand
10-21-2004, 06:15 PM
Hi

You can make it so only unlocked cells can be selected. Run this macro on the workbook open event. Change "Sheet1" as needed.


Sheet1.EnableSelection = xlUnlockedCells