我的代码有一个主要问题,应该是重置工作表,而不是关闭整个工作簿并强制重新启动。这并不是问题,只是在我添加了从On Error Resume Next开始的最后一段代码后才发生的。
Sub Reset()
Application.ScreenUpdating = False
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
If ws.Name = "Set Up" Or ws.Name = "Report" Then
Else:
Application.DisplayAlerts = False
ws.Delete
End If
Next
Worksheets("Report").Cells.ClearContents
On Error Resume Next
Application.DisplayAlerts = False
ThisWorkbook.Charts.Delete
Application.DisplayAlerts = True
On Error GoTo 0
End Sub提前感谢
https://stackoverflow.com/questions/47660926
复制相似问题