Data Validation List
 

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.

Data Validation List
 

Name it

=MYLIST

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Patrick C. Simonds" wrote in message
...
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.

Data Validation List
 

=INDIRECT("'Sheet2'!A1:A10")





"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.

Data Validation List
 

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