Hide and Unhide Rows by clicking a cell.

hi there,
Iam still new to VBA and would like some help . Thanks you to all for spending time on this.

I have a spreadsheet with about 10 headers which are lined one below the other.

What i woudl like to do is to click any of the Headers and get 2 to 5 Sub Products below it

I have attached a work sheet with headers being

XLContributor
WebContributor
Direct GEO
Under XLContributor i would like Origial and YTD Actual and Forcast.

But i want this to hide and unhide each time i click XL Contributor.

and so forth for WebContributor and Direct GEO.


Thanks you all
Joel

hi Sktneer,
Thanks for your prompt reply. i have embedded it into my worksheet and it works fine except for the click on Cell C8 which hides and Unhides the two rows below it - but it also UNHIDES all the below rows from 15 -61.

all the other cells C14 , C19 C129 C39 C48 C55 work fine. ( Ie they Unhide and Hide ONLY their respective rows and columns. I have tried to play around but was unsuccesful.