Delay in Page Setup

Bob Umlas

New member
Joined
Mar 22, 2011
Messages
10
Reaction score
0
Points
0
Age
81
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.
 
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.)
 
Back
Top