Hide empty rows of shown columns

I have a worksheet with 10 rows and 10 columns.
The rows contain values 0,1,and 2.
The first column contains some names, the other columns contain just the values mentioned above.
Three of the columns are hidden.
What I want to do is look at the columns that are visible, look at the row values, and then hide any rows for which the sum of all values is 0.
I've attached an excel file to better illustrate my pioint

Forum.xlsx

Hi - That totally does what I need. The thing that's missing, and that I cannot figure out, is how to do it dynamically.
i.e., cycle through all columns, identify which ones are hidden, and then check to see if new rows should be hidden. At any given time, different columns may be hidden.

Alright, i was able to put something together. Thought I'd share.

In the part of my code where I hide columns, I added an array to register which columns are actually showing:

Please Login or Register  to view this content.

At the end of my sheet I added a new logic to loop through all open columns and add up the cell values. If the cell value is 0 then I hide the row.

Please Login or Register  to view this content.

Hopefully this will be of use to somebody else, too.