你都试试吧,我也不知道管不管用, Sub Exit1() Dim ExcelPath As String Application.DisplayAlerts = False ExcelPath = Application.Path Application.Quit End SubSub Exit2() Application.DisplayAlerts = True Application.Quit End SubSub Exit3() Dim WorkbookPath As String WorkbookPath = ActiveWorkbook.Path If Not (ActiveWorkbook.Saved) Then ActiveWorkbook.Save End If End SubSub Exit4() ActiveWorkbook.Close True, "MYBOOK.XLs", False End SubSub Exit5() ActiveWorkbook.Close False, "MYBOOK.XLs", False End SubSub Exit6() ActiveWorkbook.Saved = True ActiveWorkbook.Close End Sub Sub WorksheetIndex() ActiveSheet.Name = "WKsheet" & ActiveSheet.Index End Sub
Sub Exit1()
Dim ExcelPath As String
Application.DisplayAlerts = False
ExcelPath = Application.Path
Application.Quit
End SubSub Exit2()
Application.DisplayAlerts = True
Application.Quit
End SubSub Exit3()
Dim WorkbookPath As String
WorkbookPath = ActiveWorkbook.Path
If Not (ActiveWorkbook.Saved) Then
ActiveWorkbook.Save
End If
End SubSub Exit4()
ActiveWorkbook.Close True, "MYBOOK.XLs", False
End SubSub Exit5()
ActiveWorkbook.Close False, "MYBOOK.XLs", False
End SubSub Exit6()
ActiveWorkbook.Saved = True
ActiveWorkbook.Close
End Sub
Sub WorksheetIndex()
ActiveSheet.Name = "WKsheet" & ActiveSheet.Index
End Sub