Print vs. Print Preview

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
 
C

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Page numbering with Merged Document and IF statements 1
Office 2010, background images do not appear in print preview nor print 0
Office 2007 Apps - Printing all graphics mirrored - Text Normal 0
VBA word change keys 0
Print with sevral different print area's 2
Print Preview Delemma, Once More Please 0
Unable to set the LeftHeader property of the PageSetup class 7
Printing App 2

Top