Code before Print but not Print Preview
 

How do I determine the difference between print and print preview i
VBA?

I want to run a bit of code in the 'before_print' procedure but
*-don't-* want it to run if its just print preview.

Anyone have any ideas ??

Thank

--
widemon

-----------------------------------------------------------------------
widemonk's Profile: http://www.excelforum.com/member.php...fo&userid=2040
View this thread: http://www.excelforum.com/showthread.php?threadid=48397

Code before Print but not Print Preview
 

As far as I know, there is no way to determine the difference
between Print and Print Preview.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"widemonk"
wrote in
message
...

How do I determine the difference between print and print
preview in
VBA?

I want to run a bit of code in the 'before_print' procedure but
I
*-don't-* want it to run if its just print preview.

Anyone have any ideas ??

Thanks


--
widemonk


------------------------------------------------------------------------
widemonk's Profile:
http://www.excelforum.com/member.php...o&userid=20402
View this thread:
http://www.excelforum.com/showthread...hreadid=483978