Excel 2007 Crashes in Vista

[JeremyJ]

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

 

[Peter T]

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

 

[JLGWhiz]

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

 

[JeremyJ]

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]

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]

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