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.
The following are the steps required to accomplish this:
- Open the worksheet that has the macro enabled
- Right-click on the toolbar and select ‘Customize’
- Click ‘Commands’ tab
- Select ‘Macros’ from the ‘Categories’ list
- Drag the ‘Custom Button’ (represented by a smiley face) under the ‘Commands’ region and drop it onto the toolbar
- Right-click on the custom button that was placed onto the toolbar
- Select ‘Assign Macro’ (You also have several options such as to change the name, change image etc)
- Select the ‘macro’ to be assigned and click OK.
- Close the ‘Customize’ window.
Whenever the macro button is clicked, it runs the macro.
Interested in macro button for Excel 2007? Click here
![[Reuse options]](http://license.icopyright.net/images/icopy-w.png){kind=small}
Related posts:
[...] 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 [...]