Add "Refresh All" command to a screen button?

[Bret1]

Can I add the "Refresh All" command to a screen button?

Thanks,
Bret

 

[mick0005]

Just record a macro of you clicking refresh all, then you can assign that to a button.

 

[mick0005]

You will find the code it generates is:

Sub RefreshAll()    ActiveWorkbook.RefreshAll
End Sub

Do you know how to assign a macro to a shape or button?