Duplex Printing on Multiple Sheets

[f_tu]

Hi all,

In a bid to save paper our printers are set to print two sided as standard. This is fine for almost all documents however a couple of users have the need to print an excel document that needs to print one sided.

The problem is when you select 1 sided printed it only applies to the first sheet!

I can work around the problem by applying one sided to every sheet before printing but these documents can be up to 20 sheets and the users may need to print over 10 a day.

Is there a way that I can make all the sheets print 1 sided?

I don’t know if this should be in the macro or VBA section as I don’t think there is away of doing this as standard. I'm not brilliant with Macros etc but could probably hash something together with a little help.

Thanks

[jwright650]

can you force it to print one sided through the printer's properties?

[f_tu]

can you force it to print one sided through the printer's properties?

Well yes/no this is my problem.

If i select one sided in printer properties in excell it will only apply to that sheet. not every sheet.

and i could set the printing defaults to be one sided but this would apply for all users and would go against our company policy. I only need this one type of document printed like this.

[Frostmore]

Hi there, maybe i'm not into the theme, but i need to print an excel table on multiple sheets, could this printing software help with this issue? By the way it's for images. Sorry for foolish q, i'm totally newbie here!