Hiding rows based on Cell Colour & Data Validation Value

Hi all,

I had a problem a while back with Active X controls disappearing when rows were hidden and not appearing in the right place once the row was unhidden. Kyle123 was able to steer me in the right direction to get rid of lots of macros and drop down boxes ad use Data Validation but as I am totally new to this I was hoping someone could help me.

I want to be able to hide or unhide all grey rows under the corresponding green row subheading and also to hide all green rows under the corresponding pink row headings. At present, if you select "NO" for a pink row it hides not just the green rows but also some pink rows underneath it. This works on the worksheet_change event (again one I have not used before)

Could anyone modify the code to stop this from happening? Ideally i want to be able to present the user with just the pink options and have them expand out all the rows required however if they mistakenly select "YES" for a pink row I do not want any rows hidden which shouldn't be if they then change it to "NO".

My thanks in anticipation

Mowgli

Attachment 179518

Bump, looking for help still!

Kyle,

Thanks so much, you have stopped me pulling my hair out in frustration as this works perfectly and is so much tidier than the mess I posted in the original thread

Can see why you have the title Guru