Hyperlink to Refresh ALL

[John19]

I'm trying to create a hyperlink in my worksheet which would active the refresh all function to fetch all external data. I'm actual trying to create a button like cell in my worksheet, that when clicked, in which ever way possible activates refresh all to activate all external data connections.

thanks[ATTACH]418284[

[pjwhitfield]

I think it should be as simple as.
1.Add an ActiveX button from the Toolbox
2.View its code
3.Add the following into the blank sub

Please Login or Register  to view this content.