Tree Diagrams

[duncs]

Hi All,
I have excel files whith lots of worksheets, To organise them Id like a tree diagram. Does anyone know of an add-in/or how to do this, so far ive been making VB coded buttons but its still a bit cumbersome.
Cheers
Duncan

 

[palusa]

Hi Duncan,

i came across this as a very nice example of tree-list:

http://andypope.info/vba/hlist.htm

Hope it could help.

_LF

 

[MintJulep]

How about just cells with hyperlinks?

 

[IRstuff]

If you couple the hyperlinks with the outlining function in Excel, you'll essentially have a tree diagram

TTFN

 

[joerd]

And if you download ASAP utilities for free from

http://www.asap-utilities.com

then you can have it create the index page automatically for you (amongs loads of other useful things)

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.