External Data Refresh if fuction is true.

[The Boondock Saint]

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

 

[Don Guillett]

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