查到了,原有名称是 .codeName
我想到的办法,又是程式。
Sub xxx()
Application.DisplayAlerts = False
maxcode% = 0
For i = 1 To Sheets.Count
cname = Mid(Sheets(i).CodeName, 6)
If cname > maxcode Then
maxcode = cname
Set NewFile = Sheets(i)
End If
Next
NewFile.Delete
Application.DisplayAlerts = True
End Sub