On screen forms - How do I get Excel to ignore unused cells?
Quote:
> I've created an on screen form, and I want the operator to be able to
> enter data in a specific cell, press Enter, and then move automatically to
> the next specific cell, ignoring the unused ones in between.
> Can it be done?
Yes, it can....
First, make sure the cells where the user is supposed to enter data are
unlocked (and all others are locked), then protect the sheet (password
optional). The final step is to include this in the Workbook_Open event
code:
Worksheets("Formsheet").EnableSelection = xlUnlockedCells
' using the name of your worksheet, of course
George