Selecting a printer

R

Rob

I have a small macro that is attached to a print button on sheet 1 that
prints the graphs on sheet 2.

My problem is that I wish to print to a printer that is not the default
printer. Can the printer be selected automatically when the macro runs.

This is what I have in the macro at present and the name of the printer is "

Sub Print_Graphs()
Sheets("Graphs").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Data Sheet").Select
Range("B18").Select
End Sub
 
D

Don Guillett

try this WITHOUT selecting the sheet

Application.ActivePrinter = "Xerox Phaser 6200B on LPT1:"
Sheets("Graphs").PrintOut Copies:=1
 

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 to specific printer -- macro 2
Excel 2010 print settings 1
Printer selection in VBA 1
Printing Macro 4
Get Name of Sheet to use in Macro 11
How to record a macro within a macro 9
Creating a print-macro that'll only print page 1? 2
Printing to seperate printer trays................... 1

Top