Excel crashes when macro gets workbook to close

[Julesdude]

Hi there all,

I'm encountering a problem with Excel 2007. I have a userform with a command button that automatically closes the userform (which takes up the whole screen and hides the workbook behind it) and exits the application/active workbook. It achieves this and the Workbook closes. However, about 2 seconds after the close, a pop-up appears with Microsoft Excel has encountered a problem and needs to close.

I've not been able to find anything on the web regarding the same problem, but I did come across an issue someone was having with the closing of a userform and having to unload the user form appropriately before close. That shouldn't be a problem with my code though as upon the exit command button procedure, I have used an unload me command to take it away before an activeworkbook.close command. The standard save pop-up comes up. I click no - not to save changes, and that's when the error occurs.

What am I doing wrong? Any ideas? Are there any rules I am not following?