Excel: don't print when cell value is 0 [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!