View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hotbird[_2_] Hotbird[_2_] is offline
external usenet poster
 
Posts: 19
Default Aborting from a "Before Print" Event

What i am trying to do is to intercept a User's print instruction, and add a
message box asking a question, and depending upon the answer, either
allowing the Print to proceed, or abort. Unfortunately Exit Sub, End, or
Stop does not prevent execution of the Print command. What line can I
insert in the following to abort the print?

Private Sub Workbook_BeforePrint(Cancel As Boolean)

End Sub