Alternate printg 2 Wsheets to diff printers w/out reassigning ptr

R

Robert L

I am trying to alternate the printing of two different worksheets to
different printers.
While I can designate the different size the each sheet calls for (one
time), I have to re-assign the needed printer each time. Am I doing something
wrong or can't I do what I want to ?
 
J

JLatham

Only one printer can be the active printer at a time. What you could do is
record a macro while going through the 'File | Print' routine (not via the
printer icon) to print one of the pages being sure to select 'current sheet'
during the process, and then continue to select the second sheet, choosing
the alternate printer and again selecting 'current sheet' as the sheet to be
printed. Stop recording. Then to do this automatically in the future,
select the first sheet and run that macro.
 
Top