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 macros 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