How to stop printing untill certain cells are filled in?

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

Is there any way to stop the people from printint untill they fill out cell
B14 with the time that the truck is leaving?
 
hi
something like this might work....
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If Range("B14").Value = "" Then
Cancel = True
MsgBox "you must fill in B14 before printing"
End If
End Sub

this is ThisWorkbook code. to use...
press Alt+F11. in the project window(far left), expand your project(file).
then expand excel objects(if needed)
scroll down and double click ThisWorkbook.
in the code window(far right), select workbook from the upper right combo box.
paste the above code in.

Regards
FSt1
 
Back
Top