Show the Forms toolbar
In xl2003 menus, View|Toolbars|check Forms

Then click on the button and draw it where you want it.

You'll be prompted to assign your macro to that button. If you choose to assign
the macro later, you can rightclick on that button and select Assign Macro.

The button from the Forms toolbar behaves differently from the commandbutton
from the Control toolbox toolbar.

Matt wrote:

how do I add a macro to a button? I am able to print a hole sheet from 1
button but I only want to print 1 page of the sheet not the whole and I can
not add the macro to the button. how can I do this?

Thanks

--

Dave Peterson