Results 1 to 3 of 3

Thread: Delay in Page Setup

  1. #1
    Seeker Bob Umlas's Avatar
    Join Date
    Mar 2011
    Location
    New York
    Posts
    10
    Articles
    0

    Delay in Page Setup



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.

  2. #2
    Administrator Ken Puls's Avatar
    Join Date
    Mar 2011
    Location
    Nanaimo, BC, Canada
    Posts
    2,027
    Articles
    79
    Blog Entries
    14
    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.)
    Ken Puls, FCPA, FCMA, MS MVP (Excel)

    Master your data with Power Query: Purchase your copy of my book M is for Data Monkey today!

    Main Site: http://www.excelguru.ca -||- Blog: http://www.excelguru.ca/blog -||- Forums: http://www.excelguru.ca/forums
    Check out the Excelguru Facebook Fan Page -||- Follow Me on Twitter

    If you've been given VBA code (a macro) for your solution, but don't know where to put it, CLICK HERE.

  3. #3
    Seeker Bob Umlas's Avatar
    Join Date
    Mar 2011
    Location
    New York
    Posts
    10
    Articles
    0
    Thanks! .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •