microsoft excel 2003 vba courses - Macros

Hi Kate, Thank you for your post, in answer to your question follow these steps:
Create your macro in the normal way, once the macro is created and named you can assign it to a button. To create the button open the Forms toolbar, View, Toolbars, Forms. On the Forms toolbar you will see the Command Button, click on the Button and draw a rectangle on the worksheet, immediatly you do so a dialog box will open asking for a macro to assign, click on the macro name of your choice. The macro is now assigned to the new button, with the button selected, (right click) you can change the default name to one of your choice, and format the text if you wish. Now by clicking on a target cell and then on the button the macro will run. I hope that is useful to you, regards Pete.