Excel Query

Boom Boom

Hi There

not sure if this can be done but going to ask as i have scoured the internet

I have a large workbook some 60 worksheets in it and it is in sections is there anyway to hierarchy the tabs or group them into a sub tab. Basically there is 6 sections A, B, C, D, E & F and each section has 10 worksheets.

What I would like is if I click on tab "Section A" it shows the 10 sheets within it and hides the rest except the header tab

not explaining myself very well so I will put it in a diagram


Section A A1 A1.1 A2 A2.1 A3 A3.1 A3.2 A3.4 A4 Section B B1 B1.1 B2 B2.1 B3 B3.1 B3.2 B3.4 B4



Section A Section B


any help welcomed

should note I am useless at macros

thanks
Boom Boom

homer911

I was going to suggest a cover sheet with macro buttons to hide and unhide sheets as appropriate

Victor

Colour the tabs?

namenotavailablE

Something like the macro-enabled workbook downloadable from the following link might be what you're looking for:

https://app.box.com/s/vrbpqm9n1y0wgpul4qat

Taltos

Simplest way beyond the above is to put Hide / Unhide in a macro and assign it to buttons for each group.

e.g.
Macro to hide all but show A

Sub mcrShowA()
'
' mcrShowA Macro
' Hide everything else

'
Sheets("A").Visible = True
Sheets("A1").Visible = True
Sheets("A1.1").Visible = True
'etc

Sheets("B").Visible = False
Sheets("B1").Visible = False
'etc

End Sub

& create a sub for each of the groupings.
Then on a control page create Buttons - label A, B etc - & assign the relevant macro.