Microsoft KB Archive/31700

{| = Excel: Avoiding &quot;Save Changes&quot; Dialog when Closing Document =
 * width="100%"|

Last reviewed: November 2, 1994

Article ID: Q31700

SUMMARY
To close a document through a macro and have Excel automatically save the document (without bringing up the dialog box: &quot;Do you want to save changes?&quot;), do the following:

=CLOSE(TRUE) To close a document through a macro and not save any changes made, use =CLOSE(FALSE)

MORE INFORMATION
In Excel versions 1.00-1.06, there is no parameter for the CLOSE function. To close a document through a macro and have it save automatically in these versions, use the following:

=SAVE =CLOSE To close a document and not save the changes through a macro in versions 1.00-1.06, use: =ERROR(FALSE) =CLOSE =ERROR(TRUE)
 * }