Menu Options being held in different workbook?

[Neil]

Hi there, im just getting into menu options, and getting used to them, and
using some useful sites, ive worked out how to have dynamic menu/name
ranges, where the length of list doesnt matter. I;ve also learned how to
have different menu options, dependant on a choice of another menu e.g.
something like:

INDIRECT(A3)


Now, what i want to do, is have al my menu options in a seperate workbook,
and reference them that way......is this possible?

if so, how?

a sample work book would do for starters,

regards, Neil

 

[Vasant Nanavati]

Neil, what exactly do you mean by "menu options"? And what do they have to
do with the INDIRECT function?

Regards,

Vasant.

 

[Debra Dalgleish]

There are some instructions here for using a data validation list in
another (open) workbook:

http://www.contextures.com/xlDataVal05.html