How to capture when a User changes the printer

J

Jacob

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
 
J

Jacob

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting macro runs real slow due to network printer - best workaround? 2
help with calling a sub procedure, doesn't compile 1
Print specific range but user to select printer 4
CHANGING PRINTER DEFAULTS 1
Specify Printer and Prompt for Number of Copies? 1
How to read settings from xlDialogPrint 1
Converting Excel worksheet to PDF then print 1
How do you give a user the choice of printer 1

Top