Private Sub 是否显示工作表_Click()
Dim r, i
r = Range("b65536").End(xlUp).Row
For i = 2 To r
If Sheets("目录").Cells(i, 2) = "显示" Then
Sheets(Cells(i, 1).Value).Visible = True
Else
Sheets(Cells(i, 1).Value).Visible = False
End If
Next i
End Sub
Private Sub 是否显示工作表_Click()
Dim r, i
r = Range("b65536").End(xlUp).Row
For i = 2 To r
If Sheets("目录").Cells(i, 2) = "显示" Then
Sheets(Cells(i, 1).Value).Visible = True
Else
Sheets(Cells(i, 1).Value).Visible = False
End If
Next i
End Sub