How to expand and collapse (unhide and hide) rows in a tree like structure

[Scott N]

Dear forum

Please see my attached spreadsheet. I have a tree like structure with three tiers of branches that I want end users to be able to collapse and expand by clicking on cells marked “-“ and “+”. I have in mind the code that would work, but I lack the knowledge to draft it. I thought a solution would be to run a SelectionChange procedure that would, if the collapse symbol “-“ is clicked, hide all rows starting from the next row to the row in which I would put a text string, eg “stop” in same column below the collapse ”-“ symbol. That way I could add new rows of data and still have the procedure work. At the moment I have coded a very inflexible series of macros linked to static cells. I am aware of Excel's built in tree structure functionality, but I dont like the look of it, and it isnt quite suited to what I need.

As always any assistance would be greatly appreciated.

Scott N