D Doug Jan 28, 2004 #1 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.
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.
N Nicky Jan 28, 2004 #2 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
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
