Sub 隐藏工作表()
Dim x As Integer
For x = 1 To Sheets.Count - 1
Sheets(x).Visible = 0
'Sheets(x).Visible = 0 隐藏工作表
'Sheets(x).Visible = -1 取消隐藏
'Sheets(x).Visible = 1 取消隐藏
Next
End Sub
Sub 取消隐藏()
Dim x As Integer
For x = 1 To Sheets.Count - 1
Sheets(x).Visible = 1
'Sheets(x).Visible = 0 隐藏工作表
'Sheets(x).Visible = -1 取消隐藏
'Sheets(x).Visible = 1 取消隐藏
Next
End Sub