Disable or VBA to prevent 'Want to save your changes' alert, just want to save it without alert

[Dojorgen]

Hey guys

I have a script that runs and closes on it's own, the problem is that sometimes i get this alert 'Want to save your changes to '***File***'?

Because of this when the script closes on it's own it does not close properly. Is there any way to disable this alert message so that it just automatically saves and closes every time without prompting this message?

I've searched around and found this but it does not seem to be working:

If ThisWorkbook.Saved = False Then
ThisWorkbook.Save
End If
ActiveWorkbook.Close

Any Ideas would be greatly appreciated

 

[NdNoviceHlp]

Application.displayalerts = False

HTH. Dave

 

[GR00007]

I believe this may work...

Application.DisplayAlerts = False

 

[Mentor82]

Hi,
Try this.

Application.DisplayAlerts=false
If ThisWorkbook.Saved = False Then
     ThisWorkbook.Save
      ThisWorkbook.Saved=true
     End If
     ActiveWorkbook.Close
Application.DisplayAlerts=true

 

[Dojorgen]

great i think it is working, thank for the help as always

 

[Mentor82]

My pleasure! ☺