printing sheets

[Doug]

Going crazy! tring to find a way to (insert something) on
sheet 2 that I can click onto, that will cause sheet 1 to
print.

 

[Nicky]

Hi Doug

Try this
copy this macro to your visual basic editor,

Sub print_sheet()
Sheets("Sheet1").PrintOut
End Sub

then insert a button or similar on Sheet2, and select this as the as
the assigned macro

I've done this on the attached.

Attachment filename: print example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=422981