 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Printing / December 2003Duplex override to single for entire workbook
Can anyone help with the following, please? Our HP printers (2300's, 4200's & 5500's) and Toshiba MFD's are set to print duplex as default. Users can override this default through the properties option within the printer dialogue box. The problem arises when a user wants to print an entire Excel workbook as single sided. The user can select print entire workbook and single sided but only the current spreadsheet comes off single sided -the other spreadsheets 'not in view' come off as duplex. Simply put, the user wants to be able override duplex, select an entire workbook for print and see hardcopy output in line with their requirements. I don't have the facilities to try, but when the user changes to single sided is (s)he doing so with only 1 sheet selected? If so, the problem should be resolvable by selecting all sheets before setting the print options. If not, it might be possible to run through each sheet and make the settings with a macro of the following variety: For Each s in ThisWorkbooks.Sheets s.PageSetup..... Next s but I don't think Excel can control the more complex printer driver settings. Someone else may be able to help on that bit. Paul C,  Signature> Can anyone help with the following, please? > [quoted text clipped - 9 lines] > duplex, select an entire workbook for print and see > hardcopy output in line with their requirements. Thanks, Paul. I did try what you suggested but it seems to have no effect - good call, though. I'll keep looking - you'd think it would be straightforward, wouldn't you? >-----Original Message----- >I don't have the facilities to try, but when the user changes to single [quoted text clipped - 27 lines] > >. This is far from an elegant solution, but it may be of some use to you. How about you duplicate the printer (simple copy and paste in Control Panel) with its duplex setting on, and then switch it off? You'd end up with two identical drivers but one of them with single-sided enabled, which would hopefully do as you require. Within Excel, you then have two possibilities. Either the user changes the printer before printing - which I suspect would be easier than having them go through the driver options to set single-sided anyway - or you could add an extra print button to the toolbar which always prints to your 'second' printer (which is actually the same printer but with a different driver setting). I suggest you try this and use the manual changing of the printer selection to see if it works. If so, let us know if you want help with adding the extra button to automate it. Paul C, Signature> Thanks, Paul. I did try what you suggested but it seems to > have no effect - good call, though. I'll keep looking - [quoted text clipped - 32 lines] >> >> .
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.