PrintQuality in Macros when Changing Printers RRS feed

  • Question

  • Hello, I built a macro on my computer (#1) and copied it onto another computer (#2) in another part of the building which uses a different default printer.  The problem is a code in my page setup that reads: ".PrintQuality = 600".  Unless we change #2's default printer to one that is in #1's part of the building, the macro stops midstream.  Both printers' properties are set to 600 dpi, so I'm not sure why it's a problem.  If I build a macro on computer #2 without changing the default printer, no code containing ".PrintQuality" even exists. 

    I hate for her to have to go to another building to print this spreadsheet, does anyone have any suggestions?

    • Moved by Mike Feng Thursday, August 4, 2011 10:36 AM VBA (From:Visual Basic General)
    Monday, August 1, 2011 1:29 PM

All replies