If you have a macro enabled worksheet and would like the user to have the option to refresh data as required, have a macro button in the worksheet to initiate refresh of the data.. This article is for Excel 2007. If you are interested for Excel 2003. click here

Click 'Office Button' icon found on the menu region

Select 'Excel Options'

Select 'Customize'

Select 'Macros' from the 'Choose commands from' pop list

Select the 'Macro' for which a button is to be created and click 'Add'. The macro is now moved to the right-side region (In the screen print, Format and Refresh are the two macros)

Select the macro and click 'Modify'

Optionally change the name of the macro and if required change the image

Click 'OK' to complete.

TrackBack URI for this entry

Comments (2)

Subscribe to this comment's feed

...
written by Dman , May 28, 2010

very helpful. just what I was looking for.
Thanks

report abuse

vote down

vote up

Votes: +0

...
written by spil , March 04, 2010

good work, worked perfect, thanks

report abuse

vote down

vote up

Votes: -1

Write comment

Name

Email

Website

Comment

smaller | bigger

Subscribe via email (Registered users only)

Write the displayed characters

Add Comment