Hide Rows with Zero Value

[Corby10]

I'm looking for a way to hide a row if it has a zero value in a specific column.

I've attached a sample workbook where, in rows 9-81, I want a row to be hidden if it has a zero value in column F. Ideally I could use a button to make the rows appear again when needed.

[KOKOSEK]

try like this:

Please Login or Register  to view this content.

assign to any button.

[Corby10]

Thanks for the response. This is allowing me to hide the rows with the button but when I click the button again, the rows do not unhide. Is there a way to do this?

[KOKOSEK]

Is not unhide because still the same rows have zero in F.
I've added other button to show all.

[MrShorty]

Are you required to use VBA for this? My first thought is to set up a simple filter on the spreadsheet. https://www.wikihow.com/Use-AutoFilter-in-MS-Excel Then, when you want to hide the 0 values, simply click on the dropdown arrow for column F and deselect the 0 values. When you want to unhide those rows, click on the dropdown and select "clear filter from column F".

[Corby10]

Are you required to use VBA for this? My first thought is to set up a simple filter on the spreadsheet. Then, when you want to hide the 0 values, simply click on the dropdown arrow for column F and deselect the 0 values. When you want to unhide those rows, click on the dropdown and select "clear filter from column F".

Yes, I'd like a button to make it a little cleaner for presentation purposes. It would be ideal to have it as one button. This is what I've used before to do the same but hortizontally, so I figured I could find a way to translate this into the vertical hiding.

Please Login or Register  to view this content.

[AliGW]

Administrative Note:

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Corby10]

Thanks for the guidance. I've updated the post.

[AliGW]

Thank you.

[sintek]

It would be ideal to have it as one button

Please Login or Register  to view this content.

[Corby10]

This works but shows the filter drop down arrow. In a perfect world, there wouldn't be the filter arrow.

[Fluff13]

Just make this change to Sintek's code

Please Login or Register  to view this content.

[Corby10]

That change didn't hide any rows.

KOKOSEK's original post is exactly what I am needing aside from it not reversing the action when I click it again.

[Fluff13]

Oops, it should be

Please Login or Register  to view this content.

[Corby10]

Thanks Fluff, anyway to stop it at a certain row, like 79?

[KOKOSEK]

Here you go:

Please Login or Register  to view this content.

under 1 button.

[Corby10]

I cannot get that to work either. My button is named Hide/Unhide if that makes any difference.

[KOKOSEK]

Try this. I've changed button type.
The rest of code is the same.

[Corby10]

Thanks for the help. I'm going to just go with the two button approach. I appreciate your work on this.