Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Preventing print when cells are blank
Hi
I have tried using the Excel icon and view code and entered a piece of code to prevent users from printing out if all cells are not completed. The problem is the cells on the current sheet are linked to a previous sheet. If the user clicks on an option button to say yes then I have linked a cell on my print sheet =$a$1 (from previous sheet) and I need to validate the cell so that if the user does not choose yes or no and leaves it blank then an error will appear preventing printing? Is this possible. I hope I have made this clear?? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preventing blank cells | Excel Discussion (Misc queries) | |||
Can Excel automatically select print area on non-blank cells? | Excel Discussion (Misc queries) | |||
check a row ignore blank cells print only those with text | Excel Discussion (Misc queries) | |||
Spacing in cells is preventing addition | Excel Worksheet Functions | |||
Preventing Duplicate Cells | Excel Discussion (Misc queries) |