Delay in Page Setup

Bob Umlas

New member
Joined
Mar 22, 2011
Messages
10
Reaction score
0
Points
0
Age
80
Location
New York
I recall seeing a property which exists only in Excel 2010 for Printing which basically doesn't make the call to the printer driver for each line in the With Activesheet.Pagesetup / End With -- but I can't find the property -- anyone remember it? Something like
.DelayCalltoPrinterDriver = True
then all the statemts following are buffered and sent once when this is set to False.
 

Ken Puls

Administrator
Staff member
Joined
Mar 13, 2011
Messages
2,524
Reaction score
6
Points
38
Location
Nanaimo, BC, Canada
Website
www.excelguru.ca
Excel Version(s)
Excel Office 365 Insider
Hi Bob,

Code:
Application.PrintCommunication = False

Be aware that if you set this to FALSE though, it completely hoses your ability to set File path/File name/File tab variables in headers and footers. (Until you set it back to TRUE, anyway.)
 
Top