I'd make sure that "Show error alert..." on the Error Alert tab of the Data
Validation dialog is checked. I have used the technique you described many
times and it has always worked.

--
Jim
"Mike D" wrote in message
...
| I'm trying to validate data that is being entered into a cell based on
a
| list that is on another worksheet in the same workbook. I have the range
| with the list set up on Sheet 3 and the cell I'm trying to validate
against
| this list is in Sheet 1. I've set up a Defined Name for the Range on
Sheet
| 3. When I set this up in the data validation screen, I pick list and I
set
| the Source equal to the name of the range. I also ensured that on an
error
| the program should stop. I can see the list in the pull down menu, but
when
| I enter data that is not in the list, the error is never trapped. If I
put a
| list on the same worksheet, the error will trap. Is there something I'm
| missing? I'm working with Excel 2003.
| --
| Mike D