Reminder message before printing
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
|