Cancel save dialog box
It should not display another message. Have you got other workbooks open than
the one you are programmatically saving ?
You can stop the message by putting this before your quit statement
Application.DisplayAlerts = False
"Sandy" wrote:
I have the following code which works fine except that the save dialog box
pops up.
Having already saved the workbook I do not want the save box to display -
how do I prevent it?
Private Sub xxxxx()
'stuff
ThisWorkbook.Save
Application.Quit
End Sub
TIA
Sandy
|