I have copied it into the code of the sheet and neither of these seem to work.

The cell E18 has a formula. Would this effect the test for value?

BTW: we have changed our policy and the test is now if E18 is NOT zero.

--
Jim


"Himani" wrote:


Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Sheets("Sheet1").Cells(18, 5).Value = 0 Then
MsgBox "Please check cell E18, value shouldnt be zero", vbCritical
Cancel = True
End If
End Sub

"Jim G" wrote:

I have a sheet that serves as a summary card for job data. Cell E18 has a
formula that finds and returns the value of the consumable levy on the job
card. Is there a way to prompt or remind users to check this if the value is
zero? A user will almost always need to print the summary, so before
printing may be a good time to remind them.

Hope you can help.


--
Jim