In the attached file I would like to suppress printing of unused items. Unused items are those items whose total is zero.
I would like to have two macros:
- one of them would hide only the data rows and leave the header and total rows visible. eg rows 167 to 168
- the second macro should hide the header and total rows in addition to the data rows. eg rows 166 to 169.
In both cases I would like the macro to be fired automatically only for printing. I know this can be done with the worksheetbeforeprint event. But how can I restore it to all visible once the print is done?