Selecting sheets in sheets

  • Thread starter Thread starter cornel
  • Start date Start date
C

cornel

Please tell me the solution of this problem:
I want an ierarchical
structure of sheets.
Example:
In Sheet1 i need to have 3 sheets(1a,1b,1c). When i see
Sheet1 i want to be able to select Sheet 1a,1b or 1c. And
so on.

A billion of thanks in advance if it is possible(I
remember I see it somewhere but I am not sure.a chance
still exists).
 
You could use the Activate/Deactivate events of the worksheets.
Set the visibility of your sub-worksheets within those events.

E.g. for "Sheet1"

sub worksheet_activate ()
Sheets ("Sheet1a").Visible = true
Sheets ("Sheet1b").Visible = true
Sheets ("Sheet1c").Visible = true
end sub

sub worksheet_deactivate ()
Sheets ("Sheet1a").Visible = false
Sheets ("Sheet1b").Visible = false
Sheets ("Sheet1c").Visible = false
end sub
 
Back
Top