Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop printing untill certain cells are filled in?
Is there any way to stop the people from printint untill they fill out cell
B14 with the time that the truck is leaving? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop printing untill certain cells are filled in?
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 "Matt" wrote: Is there any way to stop the people from printint untill they fill out cell B14 with the time that the truck is leaving? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop user from saving workbook unless cell is filled in | Excel Discussion (Misc queries) | |||
Filled cells dont appear as filled | Excel Discussion (Misc queries) | |||
Percentage of filled cells | Excel Worksheet Functions | |||
In Exel 2000, stop the blank cells (with formulas) from printing. | Excel Discussion (Misc queries) | |||
How do I stop other circles in other cells to stop selecting? | Excel Worksheet Functions |