AW: Blätter einblenden / Makro vereinfachen
09.08.2017 16:04:44
EtoPHG
Hallo Ulf,
Etwas flexibler.
Im Tabellenblatt 1:
Private Sub OptionButton1_Click()
makeVisible Array(2, 4)
End Sub
Private Sub OptionButton2_Click()
makeVisible Array(3, 5)
End Sub
Private Sub OptionButton3_Click()
makeVisible Array(3, 5, 7)
End Sub
Private Sub OptionButton4_Click()
makeVisible Array(3, 5, 6, 7)
End Sub
Private Sub OptionButton5_Click()
makeVisible Array(3, 5, 6, 7, 8)
End Sub
Im Modul1:
Option Explicit
Sub makeVisible(WSIndices As Variant)
Dim ix As Long
For ix = 2 To ThisWorkbook.Worksheets.Count
ThisWorkbook.Worksheets(ix).Visible = False
Next ix
For ix = LBound(WSIndices) To UBound(WSIndices)
ThisWorkbook.Worksheets(WSIndices(ix)).Visible = True
Next ix
ThisWorkbook.Worksheets(WSIndices(UBound(WSIndices))).Select
End Sub
Gruess Hansueli