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