Worksheet randomly freezes on on close when using exit button.

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.

Microsoft Excel

Last Comment

reitzen

8/22/2022 - Mon

reitzen

3/12/2012

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.

suvmitra

3/12/2012

put an error handler in the BeforeClose event of ThisWorkbook

On Error Resume Next
Thisworkbook.Save

ASKER CERTIFIED SOLUTION

reitzen

3/12/2012

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION