View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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