Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Aborting from a "Before Print" Event
Set the Cancel argument to True
ans=MgBox "Yes or NO",vbYesNO if ans = vbNo then Cancel = True End If -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "Hotbird" wrote in message news:Krtec.15636$4N3.13858@newsfe1-win... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Why is the "zoom" option grayed out in "print preview?" | Excel Discussion (Misc queries) | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
In Excel 2003 is there a way to prevent "Save As" and "Print"? | Excel Discussion (Misc queries) | |||
What are the System Tables named "Print Area" & "Print Titles"? | Excel Programming |