Working With Multiple Printers

You already know that Windows supports multiple printers. Using Excel with multiple printers can be a bother, however, since you must choose Print from the File menu, change the printer, and then print the worksheet. There is a way that you can have one-click printing of your worksheets on a designated printer. To do this, simply create a macro that changes the printer and then prints the worksheets. The following is a macro that will accomplish the task:

Sub GoodPrinter()
    Application.ActivePrinter = "HP LaserJet"
    ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub

When you create this macro on your system, make sure you change the printer name in the second line of the macro. It must exactly match the name of a printer on your system.

The trick is to create one of these macros for each of the printers you use. You can then modify your toolbar so that each printer has its own print button. When you then click on the button, the appropriate macro is run and you get output on the desired printer.