Skipping cells problem

[Guest]

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.

 

[Guest]

put code in the worksheet's Worksheet_Deactivate method and in the
ThisWorkbook's Workbook_BeforeSave method so that you can't leave the
worksheet OR save the workbook without putting something in the areas that
you want filled in.

--
HTH,
Gary Brown
(e-mail address removed)
If this post was helpful to you, please select ''YES'' at the bottom of the
post.

 

[Gord Dibben]

And then try to ensure users will not disable macros when opening the workbook.


Gord Dibben MS Excel MVP

 

[Guest]

Sounds exactly what I want.

Sorry im a newby to this. Could you possibly give me an overview of how I
would do this.

Many thanks!