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