Forum Discussion
Excel crashes on attempting to open VBA editor
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 .
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 😅
There must be another way around this. Any ideas where to begin?