I have writeen a VBA application which disables the save funtion in the file menu so that the user has to use a button to save the data as a different filename and do so clean up. I also have a "Cancel with out saving data" button which uses the following code

Sub Close_WorkBook()

    ' executed when a workbook is close
    
    Application.DisplayAlerts = False   ' disable alert
    Application.Quit                    ' exit the application

End Sub

The problem is that if 2 or more of the new spreadsheet are open in Excel and yser clicks on the "Cancel..." button it hangs their (and my) system. The onlyoptions are to either use Cbtrl-Alt-Delete to restart the PC or sometime it is possible to kill Excel in the task manager.

Any pointers to why this happens would be appreciated.