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
Click here for reuse options!
Copyright 2009 referpages
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 [...]