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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Statements 1
Series fill only copying and fill series greyed out 1
unable to complete deleting of printing joy 2
Want temporary color in cells needing attention 2
Controlling which cell you go to when Tab is entered 1
Fill cells 9
Mandatory cells only if another cell is filled 0
Excel Macro to automatically go to the right of the last colored cell 0

Back
Top