Oops of course. I only tested with a name in the book. So ignore my
response.

--
HTH

Bob Phillips

"olasa" wrote in
message ...

Define a name (Menu:InsertNameDefine...)
Name: list
Refers to: =DataValWb.xls!CustName
Then use Validationtab Settings, Allow:List, Source: =list

Ola

Source: http://www.contextures.com/xlDataVal05.html


--
olasa
------------------------------------------------------------------------
olasa's Profile:
http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=378975