ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Preventing print when cells are blank (https://www.excelbanter.com/excel-programming/272383-preventing-print-when-cells-blank.html)

Ann

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



All times are GMT +1. The time now is 04:43 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com