How do you run a macro before the Print Preview in Excel 2010 or Excel 2013? The 
Please Login or Register  to view this content.
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