displaying a tree structure in excel

[ellioja3]

Hello everyone! Does anyone know how to display an excel spreadsheet in a format like windows explorer (tree format). Basically I'm looking for a tool that will make my excel sheet display with a tree format. If anyone has any ideas, please email me at: merlin4154@hotmail.com

Thanks!

Ellis

 

[Thomas]

What a coincidence; I'm currently browsing the 'board for the answer to this very same question. Anyone have any tips?

For me personally, an expanding tree structure would work fine; I wouldn't necessarily need icons and such.

~Thomas

 

[Anne Troy]

Tree structure of WHAT? Your data?

Do you mean Data-Group and Outline?

 

[Ivan F Moala]

You will need the Treeview control to do this.
If your are placing this on a sheet then
look in your Cotrol toolbox [more controls]
=EMBED("MSComctlLib.TreeCtrl.2","")

If on a Userform then;
Microsoft Treeview control is what you need.

Prgming it ........look @

http://www.erlandsendata.no/english/

Repost for help.....

 

[gaby]

Hi everyone-
I have been looking for sometime for something like this. A list of your worksheets in tree structure on the left side with directories, subdirectiries containing worksheets.
There is a spreadsheet program called GS-Cal 6.0
(website Web: http://www.jps-development.com) that gives just that. Unfotunately, creating fomulas between worksheets in GS-Cal 6.0 is a real pain.

There is an Excel add in called menuzap (www.admisoft.com). Not bad, unfortunately you cannot create a formula that refers to another sheet by point and click through menuzap.

So, does anyone know how to do this in Excel.
Your help will be highly appreciated.

Thanks

Copyright © 1997-2002 JPS Development, J.Piechura

 

[tusharm]

XL with the help of Windows has this built in -- sort of. First of all, unlike a directory, it is hard to conceive of an XL environment benefiting from a tree-like display. What would it have? One level of workbooks and one level of worksheets?

The Windows taskbar (assuming you are using the appropriate versions of the OS and XL and have configured XL to work as such) gives you the workbook level 'tree.' Within XL, right-click on the VCR controls to the left of the worksheet tabs to get a 'worksheet' tree (or use the Windows menu).

{snip}
So, does anyone know how to do this in Excel.
Your help will be highly appreciated.

{snip}

 

[tusharm]

You may want to check out a new utility I just finished that was inspired by this and a couple of other discussions.
Workbook Navigator
http://www.tushar-mehta.com/excel/software/utilities/wb_nav.html

Also, this is the first time that I'm offering an option of a self-installing executable. If you use it, your comments will be most welcome, especially, if you are using something like Windows 98 (or ME) or Excel 97.

 

[m0-lca0]

Dear ellioja3.
See image at bellow for solution.

Contact me for free tools.
Regards.

 

[gwilkinson]

Try asap-utilities.com, this is one of the utilities they provide. Was free, now may cost something but well worth it. Bug free Excel add-in, I recommend it highly. NO PROGRAMMING!