Closing the workbook without saving

[tushar@excel]

Hi All,

When a user clicks close icon the excel should close without throwing message "DO You want to save changes" and without saving the changes.
I tried varoius things like display alerts, enable event, savechanges = false, but nothing seems to be working. Probably the place i am placing it is wrong.
Currently i tried by putting the above in beforeclose, window deactivate events.
Any Idea where i might be wrong.

Regards,
Tushar

[dominicb]

Good morning tushar@excel

Use this in the ThisWorkbook module. It basically tells excel that the file is saved, even if it isn't, so no message is generated :

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ActiveWorkbook.Saved = True
End Sub

HTH

DominicB