conditional printing
Paste this into your ThisWorkbook Code Window << Change as necessary
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Range("C4") = "" Then
MsgBox "Cell C4 is empty"
Cancel = True
End If
End Sub
"Conditional printing" wrote:
Is it possible to prevent printing based on zero value in a particular cell?
|