Refresh Button

[philiplynch]

I have an excel spreadsheet page that takes data from one page to come up with calculations on another. Anyway, you have to Right-Click and press Refresh Data. Is there a way to create a button that just says Refresh or Update or whatever that does the same as Refresh Data, but is there as a easy to see and click button. Thanks for your help in advance.

 

[Jonmo1]

Create a command button from the "Control Toolbox" Toolbar.

right click it, view code.

you will see some code there already, something like

Private Sub CommandButton1_Click()

End Sub

Put these lines between those 2 lines.

Sheets("sheet1").Range("A1").QueryTable.Refresh

Adjust sheetname and A1 to suit.

 

[philiplynch]

I can't find the control toolbox

 

[Jonmo1]

View - Toolbars....
if not on that list, select customize - and put a check next to "Control Toolbox"

 

[Datsmart]

From Excel Help:
"Display the Control Toolbox: point to Toolbars on the View menu, and then click Control Toolbox."

 

[philiplynch]

I tried to have things automatically refresh, but windows keeps having a message about how a macro could contain viruses, and this is going to other people, and I dont want them to see that message.

Is there a way to create a Refresh button? There would be a standard button that when clicked, would refresh the table and doesn't use macros. Thanks.