PDA

View Full Version : Excel VBA to print the entire Workbook single sided



Biz
06-15-2009, 06:45 PM
Hello, I have set up Double sided printing as the default on the server sothat all print jobs will be double-sided unless single sided printing isrequested. This is working fine. Is it possible to make VBA to print worksheets single sided ifselects the "Entire Workbook" then sets the printer preferences for Singlesided printing? Biz