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


"Ann" wrote:

i have just built a macro. how do i create a button in the spreadsheet to
run the macro? for instance, press button and the macro will run, putting in
the answer in the field next to the button?