More than one option.

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

Or:

ActiveWorkbook.Close SaveChanges:=False


"Robert Crandal" wrote in message
...
Is there a flag or variable or property that I can check
that indicates whether or not the "Do you want to save
changes?" dialog will appear when a workbook is closed??

If someone changes the contents of a cell and tries to close
the workbook without saving, Excel knows that the user
did not save the workbook. So, just to be more clear,
how can I find out if Excel knows that a "save changes"
is required??

thank you