View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default BeforePrint only running once

If you select No, you exit the sub without executing

Application.EnableEvents = True

so your subsequent print commands don't fire the BeforePrint event.



In article ,
jasminesy wrote:

The problem is: If I select no (at "continue Printing?") and then try to
print again it goes directly to the print dialog box not thrugh the macro.

Have I messed something up???