How to automate refresh data action in excel

  VNAM75 16:25 09 Aug 2008

I want to place a button in an excel spreadsheet which when pressed performs the refresh data action, rather than use right click.

The only way I know is to record the refresh data action in a macro and assign it to the button. Is there a way of assigning one action to a button without using the macro recorder?

  VNAM75 16:28 09 Aug 2008

I just did the macro and it took a few seconds, so I've really answered my own question.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?