I have just found this site and used an example in the following thread:

http://www.excelforum.com/excel-gene...using-box.html

well done royUK easy to understand.
I am a novice when it comes to macro writing but was able to understand what you did easily.

My question is:
I have a sheet were I click on L3 and rows 4:6 hide/unhide.
I was wondering if you could assist in helping me replicate this down my sheet.(which would include the same formulas, but for the values in the new cells, basically making them indipendent of each other)
So if I click on L7 then rows 8:9 hide/unhide.

I have looked at other sites but found your explanation on this example the easiest to follow.

Please let me know if my request is an easy fix or something alittle more complex.

Thank you for your time.