How to create a macro to...

[Esmatullah]

Hi dears!
Please send a macro when i exit my file don't show to me (Do you want to save your changes) just save it without showing any message. Thanks.

[GTO]

I believe that is just a one-liner.

In the ThisWorkbook Module:
[VBA]Option Explicit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub[/VBA]

hope that helps,

Mark

[Esmatullah]

Thanks dear i my problem was solved. But i have a msg box in this workbook module when insert this code and restart my file shows an error message and also i have a password for vba too

[GTO]

I am afraid I am not understanding your reply at all. Please substitute non-sensitive but similar data for anything applicable, and attach an example file.