Excel crashes when macro gets workbook to close

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?

Just an example of what I have for a survey that I created:

Unload Me
MsgBox "Thank you for taking part in this survey.  Your opinions are greatly appreciated"
ActiveWorkbook.Save
Application.Workbooks("Charting Tool Survey.xls").Close

This works well for me. However, to make it not save while closing or so the prompt does not come up, I do not know.

As a general rule, I never allow userforms to unload themselves - they only hide and then whatever routine loaded them does the actual unloading.