Problem with Data Validation not working

  • Thread starter Thread starter Rocky McKinley
  • Start date Start date
R

Rocky McKinley

I have a range validated using a list, yet when a value is entered that is
not from the list no warning appears how can this be? This workbook is also
heavily ladden with vb that is triggered by events.

The settings appear correct I have double checked.
If the named range exists and the validation settings are correct is there
some other way that validation can be accidently turned off or is this
workbook somehow corrupt? Has anyone else experienced this problem?

Excel 2002 & WinXpPro
 
The error alert may be turned off:

Select the cells that have data validation.
Choose Data>Validation
On the Error Alert tab, add a check mark to 'Show error alert
after invalid data is entered
Click OK
 
Yes the data is accepted and yes error alert is turned on, it doesn't seem
to be anything simple.
 
Back
Top