Auto save before close without asking for the same

[sujittalukde]

Whats the code line to set fot hte following?

When a file will be closed by the user, excel will not ask for "Do you want to save the changes?" Yes No Cancel
Rather it will save and close the file when the user will close the file.
Please note that this I want for a file only and not for excel as a whole.

 

[VoG]

Application.DisplayAlerts = False

Remember to set it to True before you exit your macro.

 

[Lewiy]

Private Sub Workbook_BeforeClose(Cancel As Boolean)
ThisWorkbook.Save
End Sub

 

[sujittalukde]

Thanks to duo for the code.