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.
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.
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