brodiemac Wrote:
I'm using data validation for a drop down list in several sheets in a
workbook. I have them all accessing a list that is on worksheet one.
Access
is through defining a name for the list called =salespeople. The
problem is,
I can't get the Invalid Data Stop message to work. If I access the
list
without the using the name =salespeople for the source and just use
direct
cell references it works fine. Is this a glitch or by design?

It worked for me both ways, see if in Error alert\Style you checked
"Stop"
Ilan


--
ilanr01
------------------------------------------------------------------------
ilanr01's Profile: http://www.excelforum.com/member.php...o&userid=26797
View this thread: http://www.excelforum.com/showthread...hreadid=465553