View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Cone
 
Posts: n/a
Default group excel sheets within workbook

m,
It is possible, using code, to hide and show sheets similar to what you describe.
However, that would require a minimum of 377 sheets in the workbook.
Chances are response would be slow and workbook size would be large.
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"melbournedude1"
wrote in message
Hi,
I was wondering whether it is possible to group excel worksheets under an
individual tab within the one workbook.
A example of what I would like to do is to have a set of tabs across the
bottom of the workbook to the right (as the sheet tabs appear to the left)
labelled with each month of the year. When I select a month tab, it will then
open a group of worksheets each day of that month.
I am sure that I have utilized this function in the past, but cannot workout
or remember how to create it.
Any help with this would be greatly appreciated.