Data Validation From Closed WorkBook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Framework in place: {examples]

Book1 - Main Sheet
Book2 - Lists {for Data Validation]

Is there a simple way to use Data Validation when Book2 is closed?
I have searched this site & the WEB and have had no success.

I don't know yet why the source book2.xls has to remain closed..this is an
insurmountable challenge.....

Appreciate you time & suggestions

Terry
 
Thanks for the confirmation Peo..

Peo Sjoblom said:
Not possible when it is closed, you can have it open but hidden


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


TeRex82 said:
I have a Framework in place: {examples]

Book1 - Main Sheet
Book2 - Lists {for Data Validation]

Is there a simple way to use Data Validation when Book2 is closed?
I have searched this site & the WEB and have had no success.

I don't know yet why the source book2.xls has to remain closed..this is an
insurmountable challenge.....

Appreciate you time & suggestions

Terry
Click to expand...
Click to expand...
 
Back
Top