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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
VBA-editor - Excel crashes
- Thread starter Bengt
- Start date
It seems to happen with any workbook. For a while, I thought the problem had solved itself when I opened a workbook with lots of modules and macros and whatnot, and then I could at least write a few Code Lines, but it didn't take long before this attempt also made Excel crash. Or rather, Excel itself is alive and well, and I can run macros from a spreadsheet, for instance, but as soon as I pull up the VBA editor, this happens.
Upvote
0
Joe4
MrExcel MVP, Junior Admin
- Joined
- Aug 1, 2002
- Messages
- 74,415
- Office Version
- 365
- Platform
- Windows
Does it happen on a brand new blank workbook?
I am not sure what version of Office you are running, but I assume that after you did the re-install, you were sure to also updates any and all patches & updates?
Note: I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’).
I am not sure what version of Office you are running, but I assume that after you did the re-install, you were sure to also updates any and all patches & updates?
Note: I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’).
Upvote
0
A couple of things you can try here, although the discussion is 6 years old.
techcommunity.microsoft.com
I'd open a new wb as suggested, then add a simple sub (don't import or copy one from any other wb). Your test sub would do something simple such as a message box. Save, close, reopen and see what happens when you try to edit. The code in the problem workbooks is compiled, yes? In Access there is an option to decompile then compile but I don't know if Excel has that.
Excel crashes on attempting to open VBA editor | Microsoft Community Hub
Hey guys, one of my workbooks crashes when I try to open VBA editor. Do you know how to fix the problem or extract the macros from such...
techcommunity.microsoft.com
I'd open a new wb as suggested, then add a simple sub (don't import or copy one from any other wb). Your test sub would do something simple such as a message box. Save, close, reopen and see what happens when you try to edit. The code in the problem workbooks is compiled, yes? In Access there is an option to decompile then compile but I don't know if Excel has that.
Upvote
0
Thanks for your answer. I did try to do what you suggested, but it turned out that I couldn't actually type in any code lines. All I get is the "arrow-in-a-circle" turning around, and the screen freezes. Directly after that, the crash occurs. I have also tried to open PERSONAL.XLB to see if I could access VBA directly from that workbook, but to no avail.
Upvote
0
Yes, it does happen on a brand new blank workbook. As for Excel versions, I downloaded - or rather I was instructed to download - a brand new Office version. (Using Windows 365 on a PC)
Upvote
0
As a matter of fact, I did try to open VBA in Word. That worked fine (i.e. I wrote a sub that only displayed a msgbox). However, when I tried to do the same in Powerpoint, the "Excel"-behavior occurred again: Powerpoint crashed but managed to get up on its feet again.A couple of things you can try here, although the discussion is 6 years old.
Excel crashes on attempting to open VBA editor | Microsoft Community Hub
Hey guys, one of my workbooks crashes when I try to open VBA editor. Do you know how to fix the problem or extract the macros from such...
I'd open a new wb as suggested, then add a simple sub (don't import or copy one from any other wb). Your test sub would do something simple such as a message box. Save, close, reopen and see what happens when you try to edit. The code in the problem workbooks is compiled, yes? In Access there is an option to decompile then compile but I don't know if Excel has that.
Upvote
0
So no error message of any kind? No prompt to send diagnostic data to M$? I'm not an OS expert by any means but am thinking there might be a Windows option to capture crash data.
Next time you start xl and don't do anything else, look at your task manager. Make sure you look at both applications AND processes. You should only see Excel listed once.
Next time you start xl and don't do anything else, look at your task manager. Make sure you look at both applications AND processes. You should only see Excel listed once.
Upvote
0
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?
Upvote
0
Similar threads
- Question
- Question
