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.

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

If this post was helpful to you, please select ''YES'' at the bottom of the
post.



"Paul" wrote:

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.

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


Gord Dibben MS Excel MVP

On Tue, 4 Jul 2006 06:06:01 -0700, Gary Brown
wrote:

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.

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!


"Gord Dibben" wrote:

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


Gord Dibben MS Excel MVP

On Tue, 4 Jul 2006 06:06:01 -0700, Gary Brown
wrote:

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.