How do I create a print button?

[Guest]

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!

 

[Nick]

Add this code to the button click event

Selection.Printout

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

 

[Don Guillett]

unsophisticated creators would do that

sub printit
range("a2:b22").printout
end sub

 

[Don Guillett]

unsophisticated responders such as me should have said what Nick said.