I'm not aware of it, but I've just recently started working with event driven
macros.

"Otto Moehrbach" wrote:

Barb
I want the entire macro (it calls another macro) to run when the user
issues a print command. I take it then, from what you say, that there is no
way to detect that a Print Preview was commanded. Is that right? Thanks
for your time. Otto
"Barb Reinhardt" wrote in message
...
When you print preview, the entire macro will be run. If you don't want
something to run, either delete it or move it to another module where
you'll
use it.

"Otto Moehrbach" wrote:

Excel XP & Win XP
When I click on File - Print Preview the Workbook_BeforePrint macro I
have
fires. How can I have it not fire or what code can I put in the macro to
prevent execution of the rest of the code? Thanks for your time. Otto