| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use VBA to reset data validation (=list) value to first value in that list (list is a named range) | Excel Programming | |||
| Crazy Data Validation ... List Validation Not Working | Excel Programming | |||
| data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
| data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
| data validation invalid in dynamic validation list | Excel Programming | |||
Hybrid Mode
