Hi All,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
A colleague asked me the other day if I could help him with creating a Tree Menu in XL, having created one some years ago for a project I build, I extracted it and gave it to him as a template.<o></o>
<o></o>
Being a regular on the forum, I thought it may be useful to one or two of you. It’s Named Tree Menu, and can be downloaded from:<o></o>
<o></o>
http://www.box.net/shared/pc00ytuud2<o></o>
<o></o>
If you select either a “+” or a “-,” the appropriate branck or sub-branch of the tree expands or collapse accordingly.<o></o>
<o></o>
Also, if you expend any of the branches and / or sub-branches, clicking on the logo in the top left hand corner collapse all branches and sub-branch.<o></o>
<o></o>
A colleague asked me the other day if I could help him with creating a Tree Menu in XL, having created one some years ago for a project I build, I extracted it and gave it to him as a template.<o></o>
<o></o>
Being a regular on the forum, I thought it may be useful to one or two of you. It’s Named Tree Menu, and can be downloaded from:<o></o>
<o></o>
http://www.box.net/shared/pc00ytuud2<o></o>
<o></o>
If you select either a “+” or a “-,” the appropriate branck or sub-branch of the tree expands or collapse accordingly.<o></o>
<o></o>
Also, if you expend any of the branches and / or sub-branches, clicking on the logo in the top left hand corner collapse all branches and sub-branch.<o></o>