Copy/paste this code to a general module in the workbook.

Sub refresh_rates()
Selection.QueryTable.Refresh BackgroundQuery:=False
End Sub

If not familiar with VBA and macros, see David McRitchie's site for more on
"getting started".

I'm not familiar with VBA, but I managed to get it to work. Thanks
Gord.

I had to put the button on the worksheet for the exchange rates. Is
there a way to put the button on the main worksheet (not on the same
worksheet as the exchange rates), which is in the same workbook?

/Why Tea