<div>
In your &quot;ThisWorkbook&quot; class you have a BeforeClose event. &nbsp;If you cannot replicate when you are debugging, look at the order in which procedures are being called. &nbsp;You may be trying to do something after/while the file is being saved. &nbsp;Sometimes, in older versions of Excel adding a timer helps because it allows a process to finish before moving on to the next procedure.<br />
<br />
If this produces no results, you can post your code or file to give us something to work with.
</div>


In your "ThisWorkbook" class you have a BeforeClose event.  If you cannot replicate when you are debugging, look at the order in which procedures are being called.  You may be trying to do something after/while the file is being saved.  Sometimes, in older versions of Excel adding a timer helps because it allows a process to finish before moving on to the next procedure.

If this produces no results, you can post your code or file to give us something to work with.

<div>
put an error handler in the BeforeClose event of ThisWorkbook<br />
<br />
On Error Resume Next<br />
Thisworkbook.Save
</div>


put an error handler in the BeforeClose event of ThisWorkbook

On Error Resume Next
Thisworkbook.Save

<div>
<div class="content wysiwyg-content">
I have a worksheet with vba code that works great, except that sometimes if you use the X button to close the file, it will freeze and I get the error message &quot;Microsoft Excel&quot; has stopped working. &nbsp;What could be the cause. &nbsp;I don't get any errors when I debug the code.
</div>
</div>


I have a worksheet with vba code that works great, except that sometimes if you use the X button to close the file, it will freeze and I get the error message "Microsoft Excel" has stopped working.  What could be the cause.  I don't get any errors when I debug the code.

Worksheet randomly freezes on on close when using exit button.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.