Add this code to the button click event

Selection.Printout

this will print the currently selected cells on the active sheet.





"Dan" wrote in message
...
I am creating a spreadsheet for some unsophisticated users and would like
to
have them select a range and then just click on a "print" button. I
assume I
need to create a macro and embed it in the button. Could use some help
with
that, as well.

Thanks!