Excel reinstalls features every time it opens

[Brunstgnegg]

Hello

I have a problem. This started because when running a certain VBA function my Excel Application would crash with "Microsoft Office Excel has encountered a problem and needs to close" error. The problem was that every time I ran the code in break mode it never crashed. So I read somewhere that this might be helped by running Help+Detect and Repair. I tried that and it crashed while executing. So I tried running the Microsoft Office Application Recovery. It succeeded but now every time I open Excel (Or any other MS Office Application) it runs several installs every time I use a feature which is extremely annoying. How do I solve this?

Also, does anyone know of any reason why my application would crash as described? It still does that.

Thanks in advance

[royUK]

WE need to see the code & also know which version of Excel you have

[Brunstgnegg]

The problem is that it is a VERY big sub, calling several other subs. The weird thing is that it doesn't crash when I run it in break mode, it doesn't crash if I randomly add msgboxes to different places in the code and if it has run completely once, neither of the above are needed for it to succeed the next time.

Because of the above it is very difficult to pinpoint any particular piece of code that's causing it because every time I do try to search for the problem, either via breaks or msgboxes it doesn't occur any more. If you have any suggestions regarding what to supply you with let me know.

But the main question I had was about the reinstalls, what is causing those and how do I fix it?

Thanks in advance

Oh, excel 2003

[Brunstgnegg]

Just in case someone finds this post I thought I'd give a little update. I ended up reinstalling Office and it works properly again, still havn't solved the crashing issues but that's another thread.