Worksheets code

[JEA]

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

[Pauleyb]

So, if the cell is empty, but you are on a different worksheet, you want it to print anyway? It should only not print if the cell is empty AND the active sheet is "Time Comps"? If so, the solution that comes to mind is to:

Please Login or Register  to view this content.

Pauley

[royUK]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[pike]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.