In the ThisWorkbook module codesheet paste:

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

And Save the File before Closing.

HTH


"Shariq" wrote in message
:

Hi !
I've created a book for just some calculation prupose, so it dosen't really
need any changes done to be saved, so how can I manage to do this, as to when
I close this book, that no window should appear to inform me if I want to
cancel save or no the changes.