require cell entry

[jeff]

Hi,

I think you'd have to use some VBA macro code to keep this
from happening (also from pasting in other values).

jeff

-----Original Message-----
I have set data validation to require either a 0 or 1 be

entered in the range 'g5:h4740'. Is there anyway to
require the data be entered and not allow someone to tab
through?

 

[Dave Peterson]

If your worksheet has formulas that are important, maybe you could put something
like this in them:

=if(count(g5:h4740)<>9472,"Please fill those cells!",yourotherformulahere)

Or put a nice big old message near the top (big, bold, red letters):

=if(count(g5:h4740)<>9472,"this worksheet isn't complete--don't trust it","")

=======
You do prepopulate all those cells with a nice default, don't you? That's a lot
of cells to type correctly.