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?
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