in Office 2007, use the Developer Tab, insert either a form control or active
x control, and assign the macro to it.

it's been a while since i have had to do it in Office 2003, so i cannot help
in that.

jat

hi
if 2003 then
on the menu bar....
view>toolbars>control toolbox. (you can use the forms button but i recommend
the control toolbox button.)
mouse over the controls untill you find command button. click it then click
the sheet and drag to size the button on the sheet.
right click the button and click view code.
Private Sub CommandButton1_Click()
call yourmacroname
End Sub
close the vb editor
right click the button again. click properties.
here you can set button caption, background color, font color and other
properties.
when done close the property box.
mouse over the control toolbar again and click exit design mode. close the
toolbar.

Button should be live and ready to go.

regards
FSt1