Hide/Unhide rows

**drean03** · 03-07-2010, 04:48 AM

Hello again Guys,
Need your help again.

I am trying to figure out how to hide rows automatically when 1 row or more rows have zero (0) values and/or blank.
Have attached here a working file for reference.

What I'm doing now is entering data in Sheet1(a) and/or Sheet2(a). Data here are linked to the printed sheet-Sheet1 and Sheet2.
Every month I will be printing this printed sheets numbering 10 or more and I will be adding more sheets to be printed in the future.
Before printing, I have to hide row/s having all 0 values across calculated, for all the 10 or more printed sheets. (e.g. In Sheet1, rows 10, 16, 19, 23 and 37). So this takes time.
Note that the columns in the printed sheet will probably remain the same.

For this, is it possible as well for a toggle button to be utilized for all the codes in the printed sheets to run-a. hide the rows with 0s when toggle on and unhide the rows when toggle off. Likewise, the caption will change between toggle.

This toggle button is placed in a summary sheet, but for this purpose, is placed in 1 - worksheet.

Can you guys help me code this?

Thanks in advance for the great help.

**MarMo** · 03-08-2010, 06:33 AM

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.

**drean03** · 03-08-2010, 07:49 AM

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!

**MarMo** · 03-08-2010, 08:25 AM

drean03,
I modified the code so row 27 is not hidden.
the code only hides the rows where all columns are zero.
The code is not optimal yet , but can be improved.

as for your print sheets ; how can we or VBA see if the sheet needs to be printed?
How do we distinguish the sheets ?

**drean03** · 03-09-2010, 12:15 AM

Originally Posted by MarMo

drean03,
I modified the code so row 27 is not hidden.
the code only hides the rows where all columns are zero.
The code is not optimal yet , but can be improved.

as for your print sheets ; how can we or VBA see if the sheet needs to be printed?
How do we distinguish the sheets ?

Hello MarMo. Back again here.

Yeah, I understand that those printed sheets should be enumerated and specifically defined in the code, but is it possible to put some code in those sheets to be printed and just be called upon when the toggle button is pressed? Or is it possible to put some unique identification which will be the same for the Printed sheets which will be identified by the code?

Thanks again for the great help!

Best Regards!