Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternate printg 2 Wsheets to diff printers w/out reassigning ptr
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 ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Alternate printg 2 Wsheets to diff printers w/out reassigning ptr
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. "Robert L" wrote: 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 ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|