Hi, I am unable to open my VBA editor even on a clean new workbook. Whenever I try to open the editor, it will say "out of memory". When I quit the excel application, I will receive an unexpected error (50001).
This is the first time I am facing this issue, I have >40 Gb in my storage, and previously when my storage was < 5 Gb, I can still open the VBA editor. I tried all the solution online, reinstalling excel, delete Com.microsoft.officeprefs.plist file, open a new workbook, repair disk using first aid, but none of these works. I understand that for window user they are able to delete the corrupt file in the registry, however there is no equivalent in mac. Hence, is there any other things I can do to solve this issue?
P.S. I am unable to rollback, as my previous backup is way too long ago. Any help is much appreciated. Thank you.
