试试这个
Sub TEST()
Application.DisplayAlerts = False
For Each SH In Sheets
If InStr("Sheet1,Sheet5,ABC,...", SH.Name) = 0 Then SH.Delete '引号内填入你需要保留的工作表
Next
Application.DisplayAlerts = True
End Sub
试试这个
Sub TEST()
Application.DisplayAlerts = False
For Each SH In Sheets
If InStr("Sheet1,Sheet5,ABC,...", SH.Name) = 0 Then SH.Delete '引号内填入你需要保留的工作表
Next
Application.DisplayAlerts = True
End Sub