Data Validation From Closed WorkBook

[TeRex82]

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

[Peo Sjoblom]

Not possible when it is closed, you can have it open but hidden


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"TeRex82" <[email protected]> wrote in message
news:[email protected]...
>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
>
>

[TeRex82]

Thanks for the confirmation Peo..

"Peo Sjoblom" wrote:

> Not possible when it is closed, you can have it open but hidden
>
>
> --
>
> Regards,
>
> Peo Sjoblom
>
> http://nwexcelsolutions.com
>
>
> "TeRex82" <[email protected]> wrote in message
> news:[email protected]...
> >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
> >
> >
>
>
>