External Data Refresh if fuction is true.

Is there a way you can make a external data source refresh if a function is
true.......

Ive got a few sheets which refresh automatically..... but i only want them
to refresh if a function is true.....

Any ideas?

Cheers

a macro or worksheet_change event macro
if range("a1")=1 then runmymacro

--
Don Guillett
SalesAid Software
[email protected]
"The Boondock Saint" <robport@(no-spam)inspire.net.nz> wrote in message
news:[email protected]...
> Is there a way you can make a external data source refresh if a function
is
> true.......
>
> Ive got a few sheets which refresh automatically..... but i only want them
> to refresh if a function is true.....
>
> Any ideas?
>
> Cheers
>
>
>