OP is saying that when he uses the below line in his code then his excel is crashing...

ActiveWorkbook.Close savechanges:=True
I suggested to turn off the events and try like this...

Application.EnableEvents = False
    ActiveWorkbook.Close savechanges:=True
Application.EnableEvents = True
But that is also not working for the OP and still the OP is facing the crashing issue

Any suggestion will be highly helpful to the OP

http://www.excelforum.com/excel-prog...ml#post3731542