VBA-editor - Excel crashes

[Bengt]

Don't know if this really counts as an Excel-issue per se, but this is what has happened to me. I start Excel, try to move to the developer area so I press ALT F11 (or use the icon on the developer menu, makes no difference). The VBA editor seems to start i.e. you can see the code window, but after about five seconds Excel crashes. I have been discussing this with MS Support and we worked with it for hours on end, we have uninstalled Office, deleted Office and downloaded a new copy and installed it again but to no avail. Has anyone had a similar experience? Maybe worth noting too, that this happened from one day to the next. No change in hardware.

 

[RoryA]

No they have not.

 

[Joe4]

One thing that I would like to ask you about - probably just a shot in the dark, but I am out of possible explanations: Has Microsoft introduced something of a developer's license lately, something that you must have in order for you to use VBA?

No, not that I am aware of. I think that would be pretty big news, and we would see lots of questions here about it if they did.

 

[Dan_W]

So this pretty much happened to me last week with one of my primary workbooks. I could load the workbook, and I could even load VBA Editor without it crashing (for the most part!), but the moment I indent a line of code, or go to open a userform, or rename a module - boom - it's all over. I have never really encountered that before, and so it was looking like I would need to start coming up with some innovative ways to recover the code.

On a whim, and as a last resort, I tried the Open and Repair option when opening a workbook:

Never needed to use it before. I fully expected it to gut the VBA code from my workbook, but no. It did whatever it does, and then reporeted back that there was nothing that needed repairing. But from that point on, I have not had a single problem with the workbook or the VBA Editor. Worth a try?