Get rid of save changes dialogue box

[bozic12]

Hi,
I have a user form with a close form button. The sub for this button is simple:
Private Sub CloseButton_Click()
Unload Me
Application.Quit
End
End Sub

Since Macros run in excel, after this button is clicked, the "do you want to save the changes you made to configurator.xls?" dialogue box appears when it closes excel. Is there any way to disengauge this box, or at least choose the "no" option using VBA code?

 

[MDA]

You can try this:

Application.DisplayAlerts = False

I am not sure it will work as I use it for a special save function that I created...

Below: (not related to your question, but shows the context of the syntax)
-----------------
'Save as file in CSV format
Filesavename = Application.GetSaveAsFilename(InitialFileName:="Upload_" + period + "_" + trans + ".SAL", fileFilter:="Reporting data (*.sal), *.sal&quot

ActiveSheet.SaveAs filesavename, FileFormat:=xlCSV
Application.DisplayAlerts = False
ActiveWorkbook.Close

MsgBox "The upload file has been saved", vbInformation, "Upload saved"
---------------------

Regards,

MDA

 

[bozic12]

MDA,
that did the trick!! Thank you!!