Hide Sheets Based On Value

[Hammer18]

Hello, is there VBA that can look at a specific cell (or multiple cells) on each sheet and hide that sheet if the value (or all values in the case of multiple cells) is 0? The cell reference is different on each tab and can change based on data that is added or removed. Each sheet name are different account numbers. Thank you

 

[Skyybot]

Short answer; Yes, that can be done via VBA.

 

[Hammer18]

Any idea on the code? I was only able to find if it was the same cell on each tab and nothing regarding multiple cells on one tab. Thank you

 

[kevin9999]

You need to 'inform' the code what the logic is to determine what cell(s) to assess for zero values. Is there a pattern, is there something in the sheet name?

 

[Hammer18]

I could add a word to the cell left/right of the cell that it needs to look at. Is that what you mean?

 

[kevin9999]

Probably best if you could post actual examples of sheets with both single and multiple cells to assess.

 

[Hammer18]

 

[kevin9999]

Thanks you for that. Now, is there any way of telling VBA which sheets have multiple balance cells and which ones have only one? And which column they appear in?

 

[kevin9999]

Is it possible to share a copy of your file using Google Drive, Dropbox or similar file sharing platform?

 

[Hammer18]

Workpaper

I removed all, but four sheets. I figure I could edit the code for the additional sheets on the working copy. "TB" is where the data is going to be pasted and the sheets with the account numbers is what would need to be hidden if there's no balance.