Which are you trying to work with
Thisworkbook (the workbook with the code)
or
ActiveWorkbook
Thisworkbook.Close SaveChanges:=True
or
ActiveWorkbook.Close SaveChanges:=True
--
Regards,
Tom Ogilvy
"Together " wrote in message
...
Hi,
How to save file after change without the save message? I read many
thead. But it do not work.
Application.DisplayAlerts = False
ThisWorkbook.Save
ActiveWorkbook.Close
This code does not save change!
---
Message posted from http://www.ExcelForum.com/