Debra Dalgleish has lots of notes:
http://contextures.com/xlDataVal01.html#Name
"Patrick C. Simonds" wrote:
Is there any way to use a Data Validation List and have the source be on
another worksheet in the same workbook? I would like to put the source data
on another (hidden) worksheet so that users have NO access to it.
--
Dave Peterson