put the button on the sheet (from the forms toolbar), right click on it and
select assign macro. Actually, when you draw the button on the sheet, you
should get prompted with a dialog to assign a macro.

Once assigned, when you press the button, the button fires the macro.

--
Regards,
Tom Ogilvy

Mike wrote in message
...
I have a simple copy and paste macro which pulls from a
range in one workbook to another. How can I assign that
macro to a command button (from forms)? It can't be a menu
button becuase I will have too many. Does the button call
the macro or do I need additional code (under view code).
I tried to copy my macro code but didn't work.

Thanks.