Printing several worksheets at once

[Guest]

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?

 

[Guest]

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.

 

[Earl Kiosterud]

Joel,

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