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,140
- 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
Similar threads
- Question
