Application.PrintCommunication Property (Excel)
Specifies whether communication with the printer is turned on. Boolean Read/write
Version Information
Version Added: Excel 2010
Syntax
expression .PrintCommunication
expression A variable that returns an Application object.
Return Value
True, if communication with the printer is turned on; otherwise False.
Remarks
Set the PrintCommunication property to False to speed up the execution of code that sets PageSetup properties. Set the PrintCommunication property to True after setting properties to commit all cached PageSetup commands.
Example
The following example suspends communication with the printer while setting PageSetup properties.
Application.PrintCommunication = False
With ActiveSheet.PageSetup
.PrintTitleRows = ""
.PrintTitleColumns = ""
End With
Application.PrintCommunication = True