Hi All,
I have a wb with 3 worksheets. Only one sheet requires that one cell be filled in order to print. If the cell is not filled in, I get my message box below. My problem is that I get that message on all sheets in the workbook even if I am not working in that particular worksheet.
Any ideas? I only want the message to appear in that one worksheet.



Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Worksheets("Time Comps").Range("H12") = "" Then
MsgBox "You must enter the Violation Date"
Cancel = True
End If
End Sub