excelvba

How to solve Excel VBA: Compile error in hidden module

enter image description here I have a problem about excel VBA. Excel file is created for many years. It run VBA code in 32 bit excel. However, my computer upgrade 32 bit excel to 64 bit excel. I cannot run the VBA file anymore.

It show the error: Compile error in hidden module. This error commonly occurs when code is incompatible with version, platform or architecture of this application.

Is that any solution. Thanks.

Solution

  • I have resolved same error by following these 4 steps :

    1. Open Excel file which is having issue, press Alt + F11 go into its Visual Basic Editor.
    2. From the Tools menu select References ( Note, if references option is disabled in tools menu try closing and reopening file and enable Macro before proceeding next steps)
    3. Scroll through the available References List and uncheck any item start with MISSING:
    4. Press Alt + Q once all of these reference errors have been unticked.

    If above steps does not solve issue try editing registry entries for 32/64 bit versions excel application.

    This link has mentioned all troubleshooting steps http://www.repairmsexcel.com/blog/fix-compile-error-in-hidden-module-excel

    Thanks