Excel crashes erratically after running a macro

Hello Experts,

I have developed a model for a client which keeps crashing after being used a few times. The crash is major! Excel shuts down and asks to send an error report.

This can happen after being run anywhere from 3 to 20 times. (Clicking a POST button which transfers items to a "database" type sheet).

I developed the model on a PC using Excel 2010. When this was loaded on a Mac, the user tells me that it happened periodically, and I have seen is occasionally on my PC as well.

However, the workbook has now been loaded on a server, with users across the state of Victoria accessing via Sharepoint - most using Excel 2007. Now it is happening very frequently.

I don't think the macro is at fault, it doesn't go into debug. Excel just seems to GIVE UP.

Have you seen this kind of thing before? Is there a way of "flushing buffers" or something so that Excel can keep working?

I am reluctant to post the model because it is full of personnel details, and is 2.5mb.

Any clues would be appresiated!

Regards,

David

Thanks Sixthsense and Winon,

You both suggested Application.EnableEvents.

Do you mean to wrap the code in the Event Macros - in my case Workbook_BeforeClose, _BeforeSave and _Open like this:

Please Login or Register  to view this content.

I did have one WorkSheet_Calculate event which was not working! I took the lazy approach and entered Exit Sub as the first row, thinking that I would come back and fix the code later. From what you guys have said, I suspect this macro and will delete it. See if it makes a difference.

Thanks for your help.

David

Originally Posted by :) Sixthsense :)

Please Login or Register  to view this content.

Thank you!