I am running quite a bit of code behind my spread sheet and it all compiles
just fine with out any errors.

I have found that it crashes if I am switching between the spread sheet and
other programs. And often times it crashes when I return to the spread sheet
(not even running a macro) after editing code in the VBA editor. Sometimes I
never even open the VBA Editor and it crashes. This is very confusing and
frustrating.

This has only been an issue in Vista. I did not have any problems in
Windows XP.

Please help...

Describe what your code does, also in which version of Excel

Ultra long shot, at any time is calculation set to manual.

Regards,
Peter T


"JeremyJ" wrote in message
...
I am running quite a bit of code behind my spread sheet and it all compiles
just fine with out any errors.

I have found that it crashes if I am switching between the spread sheet
and
other programs. And often times it crashes when I return to the spread
sheet
(not even running a macro) after editing code in the VBA editor.
Sometimes I
never even open the VBA Editor and it crashes. This is very confusing and
frustrating.

This has only been an issue in Vista. I did not have any problems in
Windows XP.

Please help...

It is Excel 2007. Calculation is not changed to manual at any point.

I am developing a CRM program for my company. It has about 2 megs worth of
code. The database is contained with in the workbook and it references two
other workbooks. It uses about 12 different User Forms. So what the code
mostly does is call user forms and record the data.

What confuses me is that I don't even have to run any code for it to crash.
I could be simply editing a cell (with out calling an event) and excel will
crash. The most reoccuring situation for a crash is when I edit the code and
return to the spread sheet with out saving first.



"Peter T" wrote:

Describe what your code does, also in which version of Excel

Ultra long shot, at any time is calculation set to manual.

Regards,
Peter T


"JeremyJ" wrote in message
...
I am running quite a bit of code behind my spread sheet and it all compiles
just fine with out any errors.

I have found that it crashes if I am switching between the spread sheet
and
other programs. And often times it crashes when I return to the spread
sheet
(not even running a macro) after editing code in the VBA editor.
Sometimes I
never even open the VBA Editor and it crashes. This is very confusing and
frustrating.

This has only been an issue in Vista. I did not have any problems in
Windows XP.

Please help...

Sorry I don't have any ideas, depending on the scenario there was just a
chance I might have.

Excel based CRM, interesting project !

Regards,
Peter T

"JeremyJ" wrote in message
...
It is Excel 2007. Calculation is not changed to manual at any point.

I am developing a CRM program for my company. It has about 2 megs worth
of
code. The database is contained with in the workbook and it references
two
other workbooks. It uses about 12 different User Forms. So what the code
mostly does is call user forms and record the data.

What confuses me is that I don't even have to run any code for it to
crash.
I could be simply editing a cell (with out calling an event) and excel
will
crash. The most reoccuring situation for a crash is when I edit the code
and
return to the spread sheet with out saving first.



"Peter T" wrote:

Describe what your code does, also in which version of Excel

Ultra long shot, at any time is calculation set to manual.

Regards,
Peter T


"JeremyJ" wrote in message
...
I am running quite a bit of code behind my spread sheet and it all
compiles
just fine with out any errors.

I have found that it crashes if I am switching between the spread sheet
and
other programs. And often times it crashes when I return to the spread
sheet
(not even running a macro) after editing code in the VBA editor.
Sometimes I
never even open the VBA Editor and it crashes. This is very confusing
and
frustrating.

This has only been an issue in Vista. I did not have any problems in
Windows XP.

Please help...

If you refer to ActiveSheet in your code or Selection and then change focus
to another file, it probably will crash.

"JeremyJ" wrote:

I am running quite a bit of code behind my spread sheet and it all compiles
just fine with out any errors.

I have found that it crashes if I am switching between the spread sheet and
other programs. And often times it crashes when I return to the spread sheet
(not even running a macro) after editing code in the VBA editor. Sometimes I
never even open the VBA Editor and it crashes. This is very confusing and
frustrating.

This has only been an issue in Vista. I did not have any problems in
Windows XP.

Please help...

If that is true what could I do to avoid a crash?

"JLGWhiz" wrote:

If you refer to ActiveSheet in your code or Selection and then change focus
to another file, it probably will crash.

"JeremyJ" wrote:

I am running quite a bit of code behind my spread sheet and it all compiles
just fine with out any errors.

I have found that it crashes if I am switching between the spread sheet and
other programs. And often times it crashes when I return to the spread sheet
(not even running a macro) after editing code in the VBA editor. Sometimes I
never even open the VBA Editor and it crashes. This is very confusing and
frustrating.

This has only been an issue in Vista. I did not have any problems in
Windows XP.

Please help...