Closing an Unsaved (but Changed) Workbook

[Mike]

How do I close a worksheet that I've changed (at the same
time that I close Excel), but don't want the changes to be
permanent? I tried using the following code:

ActiveWorkbook.Saved = True
Application.Quit

However, it doesn't work; it still asks me whether I want
to save the changes.

 

[Guest]

ActiveWorkbook.Close SaveChanges:=False

 

[Mike]

But once the workbook is closed, it won't reach the last
line and close Excel.

 

[Bill]

Switch the order

Application.Quit
ActiveWorkbook.Close SaveChanges:=False

Quits, but does not bring up save changes dialog

 

[Mike]

Thanks Bill!

-----Original Message-----
Switch the order

Application.Quit
ActiveWorkbook.Close SaveChanges:=False

Quits, but does not bring up save changes dialog

.