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:

Please Login or Register  to view this content.

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.