Recently noticed every time I open Excel (2007) this error block showing up. I've hit through all the threads I could find, ripped up my manuals and everything else I could think of to locate why this is happening. I hate to admit that I am not keen with VB so cannot understand why this would appear. Suggestions please? Am desperate to get this sorted out. TIA!.
When you open Microsoft Word, you get the following error message: Microsoft Visual Basic for Applications Compile error in hidden module: Auto Exec. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Click “ Help” for information on how to correct this error. If you click OK, you get another warning: Microsoft Word The macro cannot be found or has been disabled because of your Macro security settings. The only way to close the warning message and exit Microsoft Word is through the Task Manager.
Office 2013 and later A protected module contains a compilation error. Because the error is in a protected module it cannot be displayed. This error commonly occurs when code is incompatible with the version or architecture of this application (for example, code in a document targets 32-bit Microsoft Office applications but it is attempting to run on 64-bit Office). This error has the following cause and solution: Cause of the error: The error is raised when a compilation error exists in the VBA code inside a protected (hidden) module. The specific compilation error is not exposed because the module is protected. Possible solutions: If you have access to the VBA code in the document or project, unprotect the module, and then run the code again to view the specific error. If you do not have access to the VBA code in the document, then contact the document author to have the code in the hidden module updated. Show: Inherited Protected.
Download Now