bound data? If you mean have I used RowSource and ControlSource to link the
userform fields to the cells on the sheet, yes. Is this a problem?


--
Trefor


"Tim Zych" wrote:

Do you have bound data, say to comboboxes or listboxes, using RowSource
and/or ControlSource?

--
Tim Zych
SF, CA

"Trefor" wrote in message
...
Tim,

Thanks for your reply, but that's my point it doesn't crash if you step
through! AND you only get the other errors when you are trying to save.

--
Trefor


"Tim Zych" wrote:

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