Before print event - stop printing!

[wilcowoods]

Excel 2003 - I know!

Easy one I think - I have a before print event procedure that (under certain conditions) is supposed to stop the sheet from printing. So if we get to this stage:

"If Ans <> vbOK then...."

how do I stop the sheet from printing...?

Any help appreciated.

 

[Andrew Poulsom]

Cancel = True

 

[Trevor G]

What about exiting the sub routine, or cancel

if something here then
Exit Sub
Else
Something happens here
end if

or

Cancel = True

 

[jim may]

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Ans = 99
If Ans <> vbOK Then
Cancel = True
End If
End Sub

 

[wilcowoods]

Thank you all - fixed