PDA

View Full Version : Set Properties for Printing



Djblois
08-03-2010, 01:02 PM
I was wondering if there is a way to set Properties in the Print Dialog box using VBA without printing. What I mean is I want to set the amount of copies and Print Selection but I want to bring up the Print Dialog box with those options already chosen. I know how to set the Print Properties if I send the spreadsheet directly to the printer but not if I want it to open up in the Print Dialog Box.