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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prevent List Box Reference from Changing when workbook closes? 3
Linked Cells, Increment Sheet Number Ref. 3
Update data without opening file? 1
3 workbooks linked 1
Look up Values from other file based on combo box's option 2
xlfTextRef from another workbook 1
help me! about quote other workbook's sheets 4
Help with activating window from Application.GetOpenFilename 4

Back
Top