Hide/Unhide Entire Row With Button IF

[Bluewhistler]

Hello,

Been looking all over for this but still need help. I could not find the answer in other posts.

I'm trying to get a Button to hide and unhide rows depending on Column A only which is a pasted link to other sheets. The rows should hide when Cell A is empty or 0.

or 2 buttons one for hiding and the other for unhiding rows

Can someone help me out plz.

Thx.

[JBeaucaire]

Let's see your workbook...

[Bluewhistler]

I was able to put the button on the sheet but I cant edit it anymore?
I managed to get the blank rows to hide with the code on the other thread

Hi

I think the code below may help you in hiding rows with zero value in column B and un-hiding the rows where the value is no longer zero.

Please Login or Register  to view this content.

But It would be nice to be able to do this with a button.

Can't seem to upload? I get a Database error? ok I did it file was to big deleted a few sheets.
Can you get the button to hide blank rows on Sheet 11 "Overzicht"

[JBeaucaire]

No macro or VBA is needed. You can use Excel's AutoFilter to do this. Use cell A3 to filter for "non-blanks" to get the look you want, or ShowAll to see it normally.

[Bluewhistler]

No macro or VBA is needed. You can use Excel's AutoFilter to do this. Use cell A3 to filter for "non-blanks" to get the look you want, or ShowAll to see it normally.

This is good.
Can I also make a custom filter so that I have only have 5 things to chose from instead of a whole list?

[JBeaucaire]

What 5 things? I don't see any repeating codes in column A... some of the other columns have repeating values. Not sure how to advise you.

[Bluewhistler]

Thx JB.,

The autofilter works just fine. Forget my previous post.
thx for your time and sorry for the delay here.

SOLVED.