Previous Topic Next Topic

Excel: don't print when cell value is 0

Closed
WvL - Jan 18, 2011 at 07:50 AM
rizvisa1 Posts 4478 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!
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response