Sub 删除工作表()
Application.DisplayAlerts = False
With Worksheets
Sheets("A台账").Select
ActiveWindow.SelectedSheets.Delete
Sheets("B台账").Select
ActiveWindow.SelectedSheets.Delete
Sheets("C台账").Select
ActiveWindow.SelectedSheets.Delete
End With
End Sub
Sub 新增工作表()
Dim Sh As Worksheet
With Worksheets
Set Sh = .Add(after:=Worksheets(.Count))
Sh.Name = "C台账"
Set Sh = .Add(after:=Worksheets(.Count))
Sh.Name = "C台账"
Set Sh = .Add(after:=Worksheets(.Count))
Sh.Name = "C台账"
End With
End Sub