Tree Navigation

[kevin.liddle]

Excel Gurus,
Often my workbooks contain lots of sheets and a tree navigation panel (like windows explorer) to assist in finding the sheets would be amazing. I have searched on the web and found a couple of add-ins but none of them seem to enable you to sort the sheets into layers. Best described by an example:
4 sheets called 'Apple', 'Orange', 'BMW', 'Toyota'
On my tree view I would like to have the workbook name at the first level. Then at the second level 'FRUIT' (which will hold the apple and orange sheets) and 'CARS' (which will hold the BMW and Toyota sheets). Fruit and Cars are not worksheets in themselves - they are more like folders.

A solution would be great!!!

[Andy Pope]

probably because actual tab layering des not exist in excel and anything else would be user specific.

You can write your own, userform rather than task pane, using vba.

The tricky part is getting the code to understand the implied structure by tab name alone. You will probably need to include a worksheet that allows you to define the structure of your sheets.