How do I create a print button?

D

Dan

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!
 
N

Nick

Add this code to the button click event

Selection.Printout

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

Don Guillett

unsophisticated creators would do that

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