+ Reply to Thread
Results 1 to 4 of 4

It's possible?! - Something like "Folder Tree" in Windows Explorer

  1. #1
    Registered User
    Join Date
    01-31-2007
    Posts
    15

    Question It's possible?! - Something like "Folder Tree" in Windows Explorer

    Hi there!
    I need to do a links tree in a workbook.
    My sheets contains links to another sheets, and some decisions of user can change the destine place. But the user must be the option to go back, in easy way, to any step.

    Example:

    Sheet1 (user click in a button to go to Sheet5). Sheet 5 (user click to go to Sheet3), etc...

    I need to show in the first line the steps. In Sheet 5, will appear: Sheet1 > Sheet5, and "Sheet1" is a link to Sheet1, and so on...
    In Sheet3, will appear Sheet1 > Sheet5 > Sheet3, bla bla bla, bla bla bla...

    How can I do it in a easy way?! Because users can arrive in Sheet3, for example, passing by Sheet1 and Sheet5, OR Sheet1, Sheet 2 and Sheet4.

    Thanks for help! =)

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,483
    check out this post

    http://www.excelforum.com/showthread...highlight=tree

  3. #3
    Registered User
    Join Date
    01-31-2007
    Posts
    15
    This is a good topic, but isn't usefull for my project.

    What I'm doing is:
    - Choose one type of data, and see all fields and elements of it.
    - Choose another type of data, and fields of this another data, and filter the previously result with it.

    But the user can change the primary choose any time, and the process will be "restarted".

    The "tree" will work to the user see the steps that he follow, and show some restricted informations of that.

    I think something simple, without buttons, checkbox, etc... I'll try to use some cell that contains the name of the sheet, to make the link in next sheet...
    But I accept new sugestions! =)

  4. #4
    Forum Expert Carim's Avatar
    Join Date
    04-07-2006
    Posts
    4,070
    Hi,

    Take a look at Andy's solution ...
    http://www.andypope.info/vba/hlist.htm
    HTH
    Carim


    Top Excel Links

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1