excel 2007 crashes when editing VBA

[yilinwang]

I cannot edit VBA in my excel 2007. every time i try to edit module it crashes by restarting itself: EXCEL 2007 has stopped working- reopening.

can any one give me some advice? thank you.

[Ken Puls]

Have you tried running a Detect and Repair on Office?

You need to go to Control Panel --> Programs and find where you would uninstall office. Instead of uninstalling though, you should get the option to Repair. Do that and see if it makes any difference.

[ConponentProject]

I have tried this method. It didn't work. Have any new solution???

[cordelia]

Other solution could be try with an recovery tool, but i think that the first option is the best.