printing sheets

  • Thread starter Thread starter Doug
  • Start date Start date
D

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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Print Macro 5
How can I get a macro to opperate from a different sheet 3
Print Area to include text box 10
Excel VBA - Problem with Closing Print Preview 0
Automatic Page Number and Sheet Names? 2
Page Numbers/Names listed on a Summary sheet? 5
how do i print two workbook sheets onto one page side by side? 1
Merge Multiple workbook sheets into one workbook 0

Back
Top