Grouping "like minded sheets" together

[Hari]

Hi,

Please claify my query mentioned below.

On the lines of Grouping rows, columns in Excel do we have ( or why dont we
have ) the facility of grouping Worksheets. I have 40 worksheets and it wud
be great if I cud group some of them so that I might open them only when
needed. ( Dont want to use the hide, unhide option of worksheets. As per my
understanding one can unhide only one sheet at a time and its tests ones
patience. Also, last week I came across one past about accessing worksheet
by clicking right click on left scrollbar which is very good but I would
still prefer grouping sheets if the same is available.

Regards,
Hari
India

 

[Bob Phillips]

You could write a couple of macros to allow grouped hiding/unhding, and
extend the sheet tab right-click menu to have menu items to invoke them.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)