Print vs. Print Preview

[Hawk]

Is there anyway to determine within the
Workbook_BeforePrint event whether 'Print' or 'Print
Preview' was selected ?

I would like the procedure to branch depending on which
was selected.

Does anything else trigger this event?

TIA

 

[Chip Pearson]

I don't believe you can determine whether print preview is called in the
BeforePrint event.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]