Dim Sht As Worksheet Private Sub Workbook_Open() For Each Sht In Sheets If Sht.Name <> "目录" Then Sht.Visible = 0 Next End Sub Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range) If Target.Count > 1 Then Exit Sub Dim ad$ Select Case Sh.Name Case "目录" If Target.Column <> 1 Then Exit Sub ad = Target.Address Select Case ad Case "$A$2" Sheet2.Visible = -1 Sheet1.Visible = 0: [a2].Select Case "$A$3" Sheet3.Visible = -1 Sheet1.Visible = 0: [a2].Select Case "$A$4" Sheet4.Visible = -1 Sheet1.Visible = 0: [a2].Select End Select Case "2", "3", "4" If Target.Address <> "$A$1" Then Exit Sub Sheet1.Visible = -1 Sheets(Sh.Name).Visible = 0 End Select End Sub
|