Thank you, Sir
But it seems that it still can not work.

The code:

Application.DisplayAlerts = False
ActiveWorkbook.Close SaveChanges:=True

is the same as:

ActiveWorkbook.Close SaveChanges:=True


I use the VBA to analyze some data in workbook. After I finish it,
hope the workbook can close automaticly with saving the change I made

--
Message posted from http://www.ExcelForum.com