How do you run a macro before the Print Preview in Excel 2010 or Excel 2013? The 
Workbook_BeforePrint(Cancel As Boolean)
only fires when the user clicks print from the print preview screen. I want to change the users printer prior the preview showing.

I change the users printer to the XPS Printer before doing formatting as networked and redirected printers cause the macros to take 3-4 times as long. I change to the XPS printer and want to change it back to the users default right before clicking print or print preview.

Thanks

Related posts:
http://www.excelforum.com/showthread...t=#post4071622