Excel: don't print when cell value is 0

Closed
WvL - Jan 18, 2011 at 07:50 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 19, 2011 at 08:43 AM
Hello,

Please, I have an excel file with several worksheets. I made a macro that when I click a button, the worksheets are printed. There are several worksheets that only need to be printed when is cell value in the first worksheet is 1 or higher. In other words: When I click the button, only the worksheets that have a value of 1 or higher are printed. Is this possible? if yes, how?

thanx!

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jan 19, 2011 at 08:43 AM
It would be helpful had you posted you macro too. How ever, in general the idea would be that before the sheet is actually printed check for the value. If the value is what you desired then print, else skip to next sheet
0