I have created a worksheet to record customer information and need to find a
way to insure particular cells are filled in not skipped. Input cells have
been set up with data validation to enable either a list or text with
parameters such as 6 €“ 10 letters are used. There is an option to not ignore
blanks but this seems not to make any difference. When the worksheet is
locked a user can tab through the unprotected cells either selecting from the
lists or entering text that meets the validation criteria. How do I stop a
user tabing past a cell and leaving it blank?

Any help would be greatly appreciated.