John
ActiveWorkbook.Close false
works for me
or
ActiveWorkbook.Close savechanges:=false

you could also try adding
ActiveWorkbook.saved = true
before you close to clear the 'needs saving' flag

I also open stuff read only where possible
Cheers
Simon

-----Original Message-----
Hi:

I have a macro that includes the following:

ActiveWorkbook.Close Save = False

I had anticipated that this wold result in the
spreadsheet being closed but NOT being
saved. However, it appears that its being saved as its
being closed.

Can someone suggest a reason, and more important, a way
to prevent it being saved!

Thanks

John Baker
.