Using multiple checkboxes and cell content to hide columns

[RBettina]

Hello everyone. I would like to create in VBA a code which hides columns based on their content (if cell value=0) by using multiple checkboxes. For example I will have 26 checkboxes in total and when several of them are checked in , I want to hide all columns where all cell values are 0 (in the checked in rows) if at least in one column the value (in the ckecked in rows) is higher than 0, I want to keep that column. Thank you in advance for your help.

 

[My Aswer Is This]

I would need more information to understand this request.
Using a lot of checkboxes may not be the best way to do this.
So if what cell value equals 0 causes this column to be hidden?

I would suggest using a double click event.
Or cell change event script

So if I enter 0 in A1 column A will be hidden for example.

 

[RBettina]

For example if I have columns A:K, rows 1-28, and in Column A, (rows 2-28), there are 26 checkboxes. When I check in the ones in rows 2,7,11,12,25 I would like all columns from B:K to be hidden where we have in at least one row (from 2,7,11,12,25) a value higher than 0 (or the sum of values is less than 1). Thank you in advance for your help.