In Excel 2010. Can an ordinary module (not userform, class) become corrupted somehow? I can open my project, even run code, but for one particular module, can't edit, can't even delete it without Excel crashing. ?It's just code, isn't it?
Specific question: Is this a known problem with a known cause and/or solution? While I find plenty of info about corrupted worksheets etc. on the web, I don't find much about this situation. Is there somewhere I can look? Is there a remedy?Answer1:
I'd recommend the VBA Code Cleaner from AppsPro. What the CodeCleaner does is export all the modules to a folder and then re-export. So actually, if for some reason you cannot install Code Cleaner (because of corporate policy or something) then you can do this manually by right clicking on the module and take the relevant menu item.
<a href="http://www.appspro.com/Utilities/CodeCleaner.htm" rel="nofollow">http://www.appspro.com/Utilities/CodeCleaner.htm</a>