Place this subroutine in a workbook module (not a general module)

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Range("Sheet3!C10") = "" Then
Cancel = True
MsgBox "No tax value entered into C10"
End If
End Sub

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Karissa" wrote in message
...
I have looked at previous posts and the codes given have not worked.

Is there a way to stop a user from printing an excel sheet before filling
in
specific areas? If not I need help with the code associated with not
saving
before filling it out. Help?


--
Karissa