Excel crashing intermittently on save or file close - caused by vba?

[dirt]

I have developed an Excel front end for an Access (Jet ver. 4) 2000 database
(using MS Office XP). The program works fine, I can add records, query the
database, etc. using the forms I made, and so on. I have been modifying
this app to fit other databases. In the process, I have discovered a
problem where when I try to save, or when I try to close the app after
saving, Excel crashes and must be restarted. This was only annoying until I
just lost nearly an hour worth of work... I have no idea how to start
troubleshooting the cause of the crashes. I can only assume it is something
in the code I have written that is causing the issue...

Thoughts on where else I should look?

TIA

D

 

[Rob van Gelder]

I got similar when not handling userforms correctly. Creating a new userform
object, show modal and let the procedure exit.
The userform still displays, but the memory is unallocated. Stange things
happen to Excel.

 

[dirt]

Rob, thanks. That was it, when I ran the app the way it was designed, no
problem. When I was developing (fiddling with it I mean...) it would crash
when I didn't allow the userforms to properly unload before I saved and
exited.

D