Hi,

wonder if anyone might be able to help me here. I've a worksheet that contains a whole list of items in stock.

For example
Item Quantity
hot water bottle
maggi
fab
cooking oils
breakfast oats


The above is an example of what might be seen in the spreadsheet. What i'd like to be able to do is before printing it out, i want items with 0 quantity to be shown only. So i decided to hide the rows that have items with no quantity. To do this, all i could think of is to have a button that may contain codes to hide the rows. The problem with that is the button will appear there in the printout. Is there any way of making the rows hidden before printing without using a button to trigger the code?

Thank you in advance