Do not allow printing untill required cells are complete

[adupuy]

I'm working on a workbook with two work sheets. I want on sheet two range ("t3") to be required before user can print sheet two. I want users to be able to print sheet one even if the required cell is blank in sheet two. below is the code i have entered that keeps users from printing both sheets untill required cell is filled in.

Private Sub Workbook_beforeprint(Cancel As Boolean)
If Sheet2.Range("t3") = "" Then
MsgBox "Must Enter Mileage"
Cancel = True
End If

End Sub

Please help..

 

[VoG]

Hello and welcome to MrExcel.

Try

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Sheet1" Then Exit Sub
If Sheet2.Range("T3").Value = "" Then
    MsgBox "Must Enter Mileage"
    Cancel = True
End If
End Sub

 

[adupuy]

Awesome!! Thanks alot, I was on the right track trying to use the active sheet code but could not seem to get it right...

 

[Norie]

Adupuy

Your code should work, where you having problems with it?

VoG

Won't that stop sheet 1 from ever being printed?

 

[VoG]

VoG

Won't that stop sheet 1 from ever being printed?

Nope