| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Stuck...
Here's an example
http://www.contextures.com/xlDataVal05.html Regards, Peo Sjoblom "Mike" wrote: Thanks for the reply.... I have done both steps but I still get the error message "You may not use references to other worksheets or workbooks for data validation criteria". What have I missed? Thanks again, Mike. "Peo Sjoblom" wrote: 1. If you mean datavalidation you need to name the list in the other workbook. 2. The other workbook needs to be open, you cannot use a list from a closed workbook Regards, Peo Sjoblom "Mike" wrote: How do I link to (and be able to choose data from) a drop list in another workbook? Every time I try to type in the path, an error message says its not allowed. Is there a way around this problem? Thanks for any help.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Still stuck on macro... | Excel Discussion (Misc queries) | |||
| My mouse suddenly behaves as if the left click is stuck | Excel Discussion (Misc queries) | |||
| stuck | Excel Worksheet Functions | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
| Select is "stuck" | Excel Discussion (Misc queries) | |||
Hybrid Mode
