Print vs. Print Preview
 

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

Print vs. Print Preview
 

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


"Hawk" wrote in message
...
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