I have several worksheets in a workbook all configured to print double-sided.
If I want to print say 4 worksheets single-sided, only the worksheet which is
open prints single-sided and the rest print double-sided. I'm using Sharp
printer and according to Sharp, the problem is with Excel. Any ideas or
workaround?
--
koobro

try this, not sure if it will work.
go to print menu and select entire workbook. then go to options and select
either single sided or double sided.


"koobro" wrote:

I have several worksheets in a workbook all configured to print double-sided.
If I want to print say 4 worksheets single-sided, only the worksheet which is
open prints single-sided and the rest print double-sided. I'm using Sharp
printer and according to Sharp, the problem is with Excel. Any ideas or
workaround?
--
koobro

Joel,

Do four print commands. One sheet at a time. If you do it frequently, record a macro.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Joel" wrote in message
...
try this, not sure if it will work.
go to print menu and select entire workbook. then go to options and select
either single sided or double sided.


"koobro" wrote:

I have several worksheets in a workbook all configured to print double-sided.
If I want to print say 4 worksheets single-sided, only the worksheet which is
open prints single-sided and the rest print double-sided. I'm using Sharp
printer and according to Sharp, the problem is with Excel. Any ideas or
workaround?
--
koobro