Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
prohibit printing based on input
Barb, see if this will work for you, put in the this workbook code
Private Sub Workbook_BeforePrint(Cancel As Boolean) Dim Cel As Range 'change your range here For Each Cel In [b1:b6] If IsEmpty(Cel) Then Cel.Select Cancel = True MsgBox "Missing data", vbExclamation, "Can't Print Without All Data" Exit Sub End If Next Cel End Sub -- Paul B Always backup your data before trying something new Using Excel 97 & 2000 Please post any response to the newsgroups so others can benefit from it ** remove news from my email address to reply by email ** "Barb" wrote in message ... Is it possible to prohibit the printing of a form until all required fields contain values? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to input pictures automatically based on cell input? | Excel Worksheet Functions | |||
run macro with input msg based on cell input | Excel Discussion (Misc queries) | |||
Prohibit users from modifying | Excel Discussion (Misc queries) | |||
Prohibit entry of special characters | Excel Worksheet Functions | |||
prohibit closing a workbook | Excel Discussion (Misc queries) |