Previous Topic Next Topic

Excel: don't print when cell value is 0

Closed
WvL - 18 Jan 2011 à 07:50
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 19 Jan 2011 à 08:43
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
19 Jan 2011 à 08:43
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

Similar discussions

Convert number to spelling
Sukumar -
mrwagh85 -

28 responses
How to extract data from one excel file to another
zamorin -
zamorin -

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

6 responses