Step through the macro and find the point that immediately precedes the
crash. Hopefully you can reliably reproduce the error and work around the
bug.


--
HTH

Tim Zych
SF, CA


"Trefor" wrote in message
...
I have been jointly developing a form with a college and she started
getting
"Microsoft Office Excel has encountered a problem and needs to close. We
are
sorry for the inconvenience." In other words it crashed with no errors or
indication of what the problem might be.

If you disable macro's it comes up fine. I then stopped the Auto_Open sub
running by simply making the first line an Exit Sub, saved it, re-ran the
Auto_Open sub routine from VBE and it works fine. Save the file and re-run
it
works fine. Re-start, exit without saving and it crashes again on
re-start. I
also get intermittent "Automation Error" normally when trying to save the
file. The other error I get is "Not enough system resources to display
completely". I have tried deleting some of the form content and some of
the
code and you think you have fixed it, you save it, re-start it and it
works
fine. Then you make a change, which could be as simple a typing a
character
into a cell, save it, exit re-start it and it crashes again.

In researching this error I have read comments about running out of memory
and my college only has 512MB, but I have 2GB. I also found a note about
zooming to 100%, and this appeared to work i.e. changing two sheets from
80%
to 100%. Then made a simple change (cell update) and I am back to where I
started.

There are only 250 lines of very basic code, but there are a lot of
userform
details so it is not easy for me to paste here. Any ideas?

--
Trefor