Menu Options being held in different workbook?

  • Thread starter Thread starter Neil
  • Start date Start date
N

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
 
Neil, what exactly do you mean by "menu options"? And what do they have to
do with the INDIRECT function?

Regards,

Vasant.
 
Back
Top