+ Reply to Thread
Results 1 to 2 of 2

How to capture when a User changes the printer

  1. #1
    Jacob
    Guest

    How to capture when a User changes the printer

    Greetings all,
    I have VBA code in the Workbook.BeforePrint procedure that sets the
    print area and other items, and it works well. It seems that these
    settings are used for the current Application.ActivePrinter only. I
    say this because after the BeforePrint procedure fires, if the User
    changes the printer in the Print dialog box, any settings I had set are
    not applied to the new Application.ActivePrinter.
    For example, if I set the scaling to print 1 page wide on the original
    printer (in the BeforePrint procedure), then choose a different printer
    in the Print dialog box, the newly selected printer has the scaling at
    100%.

    Any ideas about catching the Application.ActivePrinter change without
    writing code that uses the Windows API to catch messages to the
    application? Alternatively, is there a way to 're-fire' the
    BeforePrint procedure?

    TIA for your replies,

    Jacob


  2. #2
    Jacob
    Guest

    Re: How to capture when a User changes the printer

    To be clear...
    I need to find out about the printer changing AFTER the BeforePrint has
    fired.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1