Thanks for all the help but I'm afraid none of it worked. I mentioned I'd
saved an old version that worked. When I got back to the office today I
checked and it was more complete then I remembered - just some forms needed
to be changed, a little code rewritten, the spreadsheet formatted and locked
up and after I'd done that and saved it and checked it and double checked
it, everything worked and then ------ I added the final feature - the spell
checker! And the same thing happened. I guess somehow that's what the
problem is, either a bug in VBA or in the way I enacted the CheckSpelling
method.
I had done everything everyone else suggested (with the exception of
OpenOffice). We tried opening it in Excel 2000 and it still crashed. I
could not open the spreadsheet so could not export modules, and in general,
I had tried everything I could think of.

Thanks to everyone,
Perry.


"Stephen Bullen" wrote in message
...
Hi Perry,

Help! I wrote a vba macro for Excel XP, ran it (and it ran without
problems), saved the spreadsheet, exited Excel and later reloaded the
spreadsheet - but now while loading the spreadsheet, Excel crashes!
When
Excel "recovers" the spreadsheet it deletes the VBA code.

Deactivating the Macro doesn't help. Is there someway of retrieving the
code? There is a lot of data in there I do not want to re-enter.

I've found that Excel 2000 and Excel XP are good at opening each-other's
workbooks when this opens-then-crashes occurs. I.e. if opening in Excel
2000 crashes, Excel XP will open it fine and vice-versa. So you might
want
to try opening it in a different version of Excel, if you have access to
them.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.co.uk