Reminder message before printing
hi,
try this...
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim rng As Range
Set rng = Range("E18")
If IsEmpty(rng) Then
MsgBox ("cell E18 is zero or empyt." & vbNewLine _
& "Printing canceled.")
Cancel = True
End If
End Sub
regards
FSt1
"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
|