Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Printing Double-Sided
Hi,
I am trying to do double sided printing in excel with multiple worksheets (20). In order to print double-sided, I need to (within Excel) select File - Print - Properties and select "Flip on long side" in order to adjust one worksheet. Excel does not change the printing preference for all desired worksheet if i select them all at once (it jsut change whichever worksheet is active). Is there a quicker way to do it (even VBA will be good for me) so that i can choose the preference once and it will apply to all worksheets? I know that i can (within window) go to Printer/Fax, right click on the printer and select Property, and select "Flip on long side". However, this only works for new Excel files or existing Excel files that have not been modified for the printing preferences. However, I currently have tons of Excel files (with modified, incorrect printing preferences) that I would like to print. Can anyone offer some soln so that i do not need to go through each worksheet in all these files? Much Appraciated! Drawde However, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing two tabs of the same worksheet to one double-sided page | Excel Discussion (Misc queries) | |||
Printing multiple worksheets double sided | Excel Discussion (Misc queries) | |||
How to print single sided versus double sided? | Excel Discussion (Misc queries) | |||
Print double-sided pages in Excel | Excel Discussion (Misc queries) | |||
Enable Double sided printing contiuously when printing multiple s. | Excel Discussion (Misc queries) |