View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
JMay JMay is offline
external usenet poster
 
Posts: 468
Default 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?