Workbook_BeforePrint
ans = MsgBox(msg, vbYesNo, title)
If ans = vbYes Then
' do it
End If
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Squid" wrote in message
...
I want the test the result of a msgbox in the
Workbook_BeforePrint event. If the users clicks Yes,
print the spreadsheet, if the user clicks No, do not print.
I forget how to accomplish this.
TIA
Mike
|