Hide/Unhide rows using a macro

[Jazzy Max]

Hi All,

I am trying to hide and unhide certain rows using a macro...which I have already recorded.

As shown in the attached spreadsheet.

I just need the linking statement that will enable the blue button in A1. At the moment, clicking the blue button "Brand" will hide the three rows below it...I want it to do both hide and unhide.

Thank you for your assistance.

P.S - I have searched the forums and tried a few link statements but was unsuccessful in attaining my desired result.

[Mayweed]

Try this, (attached) I'm sure anyone here will give you a better way of doing this; I'm still learning!

Please Login or Register  to view this content.

[Jazzy Max]

Cool, thank you for that...Im sure there is a simpler way to this one...but in the meantime I will use this as.

But if there is another way of doing this please let me know.

Thank You

[Mayweed]

Ok. I've tried to come up with a simpler solution (attached).

[Jazzy Max]

Ok. I've tried to come up with a simpler solution (attached).

Absolutely perfect!! Thank You very very much.

[sunnybody1987]

neat piece of code .... made my life real easy..