Exit BeforePrint if PrintPreview

[Mat]

Hi,

I have code in my Workbook_BeforePrint routine, but I don't want it to be executed if the event is triggered by the PrintPreview, so I can I know if the event has been raised by the PrintPreview button instead of the Print button?

Thank you

 

[Andrew Poulsom]

Sorry, it's not possible to determine whether print print or print preview caused the event to fire. Here's a possible workaround:

http://stackoverflow.com/questions/...n-print-and-print-preview-events-in-excel-vba

 

[Mat]

That's sad
Not even using Application.Caller or something similar to know what button has been pressed??