Try this//

ActiveWorkbook.Close Savechanges:=True
Application.Quit

If this post helps click Yes
---------------
Jacob Skaria


"N1KO" wrote:

Hi,

I have this simple bit of code in my close macro

ActiveWorkbook.Save
Application.Quit

When this runs it comes up with the "Do you want to save changes" dialog box
when i've already saved it automatically.

Is there anyway of getting rid of the Dialog Box?

Thanks in advance