printing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

is there a way to print worksheets in a workbook to different printers and retain the setting?
 
Hi Moe

With VBA you can change the activeprinter and print the sheet.
And set it back to your default

You can change the activeprinter to the printer you want like this
Application.ActivePrinter = "hp officejet k series on Ne00:"

To know the names of your pinters
Change to it in the ctrl P dialog (Cancel after you choose the printer )
and run this so you know the name

Sub nameprinter()
MsgBox Application.ActivePrinter
End Sub

If you print with code then look at Printout in the VBA help
You can fill in the name of the printer then
 
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 worksheet 2 on back of worksheet 1, etc.... 1
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
print range won't print 2
Epson XP-3150 not printing 2
Problem printing all worksheets in colour 1
Set default cell format while retaining overrides 3
Set the print order of worksheets when printing entire workbook 2
printing multiple worksheets in a workbook 1

Back
Top