Refresh All button

[Wrecker1]

Where would I find the code for the "Refresh All" button located on the External Data Toolbar. I would like to create my own button
and place it on the worksheet.

Thanks
Wrecker 1

 

[TJPCTeach]

From the Menu bar select View > Toolbars > Customize
From the Customize window select the Commands tab
Under Categories: select Data
Under Commands: you will find Refresh All
Left click and hold on the Refresh All Icon and drag to an existing toolbar.

 

[Wrecker1]

Thanks for the info... but I would like to create a button on the worksheet, not on the toolbar. I know how to create the button. What I need help with is the code for "refresh all".

Thanks
Wrecker 1