Sub 留右删除() '保留最右侧表格
Dim r As Integer
Application.DisplayAlerts = False
If Sheets.Count > "2" Then
For r = (Sheets.Count - 1) To 1 Step -1
Sheets(r).Delete
Next
End If
Application.DisplayAlerts = True
End Sub
Sub 留左删除() '保留最左侧表格
Dim l As Integer
Application.DisplayAlerts = False
For l = Sheets.Count To 2 Step -1
Sheets(l).Delete
Next
Application.DisplayAlerts = True
End Sub
Sub 留指定删除() '留指定表,删除其余工作表
Application.DisplayAlerts = False
Dim sht As Worksheet
Dim zd As String
zd = InputBox("请输入需保留工作表的标签名,仅限一个:")
For Each sht In Sheets
If sht.Name <> zd Then
sht.Delete
End If
Next
Application.DisplayAlerts = True
End Sub
4.删除除指定表外的其他sheet表
于 2024-05-13 11:43:34 首次发布