excel 2003 visual basic intermediate course - Excel, macros

Hi Nikki

Thank you for your question.

First you would need to add a button to a toolbar, then assign the macro to the button you have created.

To add a button to a toolbar:
1. Go to Tools - Customise - Commands then select Macros from the Categories list on the left.

2. From the Commands list on the right, select the Custom button. Drag and drop this onto an existing toolbar to the position where you want the button to be.

What displays on the button can be customised by right-clicking on the button, while you have the Customise dialogue box open. Close the Customise dialogue box when finished.

3. To attach a macro to the button, right-click on the button you have created and choose Assign Macro.

4. Select the macro you wish to attach to the button and click OK.

I hope this helps.
Amanda