Nov 27 2017
07:39 AM
- last edited on
Jul 25 2018
09:44 AM
by
TechCommunityAP
Nov 27 2017
07:39 AM
- last edited on
Jul 25 2018
09:44 AM
by
TechCommunityAP
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 workbook?
Thanks a lot
Nov 27 2017 08:54 AM
Hi,
Bad macros may have caused this!
You have to numb these macros to be able to open the VBA editor.
Try this:
Go to Developer Tab >> Macro Security >> Macro Settings
And make sure that the macro setting is (Disable all macros with notification).
Then go to Trusted Documents and press Clear button.
After that, save and close the workbook, then open it again.
Try to open the VBA editor, and look what the problem is.
Nov 27 2017 08:59 AM
Hi thank you for reply! I think it must be something with macros but I have tried to disable macros and clear trusted documents but my spreadsheet crashes or freezes on saving.
Nov 27 2017 09:31 AM
Another try
Useful Link:
Nov 27 2017 01:27 PM
After trying everything I have killed outlook.exe process and it suddenly worked LOL :D
Nov 26 2018 02:35 AM
many users repair, uninstall, reinstall office and some users even reinstall windows and the solution is quite simple right in front of your nose. all these problems happened due to the new Beta feature for Region setting using unicode UTF-8 for worldwide. correction of this stupid error which cost me a lot of time and effort is very simple.
control panel >> Region >> Administrative tab >> change system locale >> untick the box " Beta: Use Unicode UTF-8 for world wide language support" . that's it problem solved .
Jan 12 2019 07:56 AM
The solution said works.
Thanks for the solution
Feb 27 2019 12:03 PM
May 30 2019 07:39 AM
I still get the above described error, but my Region Settings does not have the offending Beta box.
Sep 03 2019 07:55 AM
@DATA00 Excellent answer! It worked, thanks!
Sep 05 2019 09:29 AM
Mar 26 2020 12:42 AM
hallelujah, you saved my day@DATA00
Oct 18 2021 02:33 AM
@DATA00, on the surface this sounds like a great solution. Problem is — it's not a solution, it's a workaround. I thank you for the reply (it has obviously been helpful to many), but I would love some help getting deeper into the issue (which I too, am experiencing).
See, I reside in a country that utilized RTL text and so many of my macros only work to begin with thanks to said beta feature. That's how I got to turning it on to begin with :grinning_face_with_sweat:
There must be another way around this. Any ideas where to begin?
May 06 2022 08:15 PM