view -> toolbars -> forms

hover over the icons to find the button named "button"

click and drag a new button onto your sheet.

now, you have a button on your sheet, double click on it to open up the visual basic editor.

in the code ...

Sub Button1_Click()
ActiveSheet.PrintOut
End Sub

save and close the editor.

save the worksheet.



this is the working code. i don't have time to tweak it even more to pick paper trays and what nots, but this is good to go. make sure to set your print options and save. (fit to one page, landscape, blah blah blah)

to edit the button, don't click on it .. right click on the edge of it and then check what you can do with it. (rename, move)