Print vs. Print Preview

  • Thread starter Thread starter Hawk
  • Start date Start date
H

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
 
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 (e-mail address removed)
 
Back
Top