I have the following code at the end of a macro, but I am still getting the question "Do you want to save the file?"
Hoping someone can explain where I have gone wrong.
When the user clicks the button associated with this macro, it executes a number of things before closing the file and exiting the application. (All of these functions work perfectly)
What am I missing? I want the file to close and quit the application.
There are no errors, just the msg to "Save/Don't Save/Cancel?"
Note: I do not have the entire code listed here, just the last action
' SAVE THE FILE AND EXIT EXCEL
Application.DisplayAlerts = False
ThisWorkbook.Save
Application.DisplayAlerts = False
Application.Quit
End Sub
Hoping someone can explain where I have gone wrong.
When the user clicks the button associated with this macro, it executes a number of things before closing the file and exiting the application. (All of these functions work perfectly)
What am I missing? I want the file to close and quit the application.
There are no errors, just the msg to "Save/Don't Save/Cancel?"
Note: I do not have the entire code listed here, just the last action
' SAVE THE FILE AND EXIT EXCEL
Application.DisplayAlerts = False
ThisWorkbook.Save
Application.DisplayAlerts = False
Application.Quit
End Sub