Hi John,

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!


The proper syntax is:

ActiveWorkbook.Close SaveChanges:= False

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com