Tree View of spreadsheet tabs: is it possible?
 

PROBLEM:
Suppose I have a workbook with the following sheets:

USA-north
USA-south
USA-east
USA-west
USA-west-region1
USA-west-region2

CAN-north
CAN-south

QUESTION:
Is there any way to display a "collapsable tree view" of the sheets?
(in a side panel that occupies the entire left side of the GUI, similar
to what you would see in msft windows "explorer tree view"). It would
be nice to have a view where the topmost 'nodes' of the tree would be
USA and CAN which are collapsable and expandable to reveal and
hide the various child nodes associated with them.

RATIONALE:
The reason for this request is that this option (if available) would
help
to visualize the data in the sheets more easily as well as avoid the
effect
of 'runaway spreadsheet tabs' that scroll off the side of the screen at
the
bottom. In other words, a collapsable "show/hide" tree view would make
it easier to navigate the various subgroups of spreadsheet tabs.

Absent availability of this feature, is there an alternative approach
anyone
has found, assuming I am not the first person in the world to think of
this
idea?

Tree View of spreadsheet tabs: is it possible?
 

Most likely is is not possible w/o coding.
Here is a utility program which does the following:
1) Sort all the sheets in order
2) Create a summary sheet listing all sheets' names
3) Links to each individual sheet.

Download at: http://www.xldatasoft.com/downloads/SortSheet.xls
This may not what you want, but it helps you to visualize the organization
of your sheets.
Hope this helps.

--
Best regards,
---
Yongjun CHEN
==================================
- - - - www.XLDataSoft.com - - - -
Free Tool & Training Material for Download
==================================

wrote in message
ups.com...
PROBLEM:
Suppose I have a workbook with the following sheets:

USA-north
USA-south
USA-east
USA-west
USA-west-region1
USA-west-region2

CAN-north
CAN-south

QUESTION:
Is there any way to display a "collapsable tree view" of the sheets?
(in a side panel that occupies the entire left side of the GUI, similar
to what you would see in msft windows "explorer tree view"). It would
be nice to have a view where the topmost 'nodes' of the tree would be
USA and CAN which are collapsable and expandable to reveal and
hide the various child nodes associated with them.

RATIONALE:
The reason for this request is that this option (if available) would
help
to visualize the data in the sheets more easily as well as avoid the
effect
of 'runaway spreadsheet tabs' that scroll off the side of the screen at
the
bottom. In other words, a collapsable "show/hide" tree view would make
it easier to navigate the various subgroups of spreadsheet tabs.

Absent availability of this feature, is there an alternative approach
anyone
has found, assuming I am not the first person in the world to think of
this
idea?

Tree View of spreadsheet tabs: is it possible?
 

Another option from Debra Dalgleish's site:
http://contextures.com/xlToolbar01.html

wrote:

PROBLEM:
Suppose I have a workbook with the following sheets:

USA-north
USA-south
USA-east
USA-west
USA-west-region1
USA-west-region2

CAN-north
CAN-south

QUESTION:
Is there any way to display a "collapsable tree view" of the sheets?
(in a side panel that occupies the entire left side of the GUI, similar
to what you would see in msft windows "explorer tree view"). It would
be nice to have a view where the topmost 'nodes' of the tree would be
USA and CAN which are collapsable and expandable to reveal and
hide the various child nodes associated with them.

RATIONALE:
The reason for this request is that this option (if available) would
help
to visualize the data in the sheets more easily as well as avoid the
effect
of 'runaway spreadsheet tabs' that scroll off the side of the screen at
the
bottom. In other words, a collapsable "show/hide" tree view would make
it easier to navigate the various subgroups of spreadsheet tabs.

Absent availability of this feature, is there an alternative approach
anyone
has found, assuming I am not the first person in the world to think of
this
idea?

--

Dave Peterson