require cell entry

J

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
Click to expand...
entered in the range 'g5:h4740'. Is there anyway to
require the data be entered and not allow someone to tab
through?
 
D

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.
 
Top