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