Hide/Unhide rows

Hi

I added some code and another button on the workbook and renamed it.
Perhaps this might help you.
The code hides the rows with zero values , or it unhides all rows in the activeworksheet.

Hello MarMo,

First of all, thanks for your help. I was thinking all are quite busy now.

I tried the attached file. It almost worked fine, but it seems row27 is also being hidden. It's not suppose to hide that row since there are data on column J27 and K27.

Another thing is I have around 50 Printed worksheets out of 130 worksheets in my file.
Would it be possible to insert some code in these 50 Printed worksheets then it will be called upon when the toggle button is pressed? Note the toggle button will be placed in some other worksheet.

Thanks!