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 a macro button for Excel 2007? Click here

TrackBack URI for this entry

Comments (0)

Subscribe to this comment's feed

Write comment

Name

Email

Website

Comment

smaller | bigger

Subscribe via email (Registered users only)

Write the displayed characters

Add Comment