Application.PrintCommunication Property (Excel)
Specifies whether communication with the printer is turned on.
Version Added: Excel 2010
A variable that returns an Application object. Return Value
True, if communication with the printer is turned on; otherwise False.
PrintCommunication property to False to speed up the execution of code that sets properties. Set the PageSetup PrintCommunication property to True after setting properties to commit all cached PageSetup commands.
The following example suspends communication with the printer while setting
Application.PrintCommunication = False
.PrintTitleRows = ""
.PrintTitleColumns = ""
Application.PrintCommunication = True
Did you find this helpful?
( 1500 characters remaining)
Thank you for your feedback