Select the button icon on the 'Forms' toolbar and place it whereeve
you want it on the sheet. Then right click on the button and selec
'Assign macro'. Then select record and perform the steps required t
print one sheet. Once you are done, stop recording the macro and yo
are good to go.
If you want to generalise it you can analyse the code and make change
to it. (Alt+f11) shows you VB Editor where your macro code is in one o
the Modules.