Using Excel 2007 I created a drop down list with a different tab as the
source. The error alert box is checked but when I enter something other than
what is on the drop down list it allows it and does not give me an error
message. Is there a work around or is this feature not available in 2007?

Thanks.