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 <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->
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 <!-- / message --><!-- BEGIN TEMPLATE: ad_showthread_firstpost_sig --><!-- END TEMPLATE: ad_showthread_firstpost_sig -->
<!-- controls -->
