Sep 06 2022 12:42 PM
Sep 07 2022 02:11 AM
This Compile Error In Hidden Module error message usually appears when there are 32-bit add-ins versions of Office that are incompatible with the newer Excel version.
Uninstall all AddIn's and restart Excel, when the error is fixed, activate one AddIn at a time to see which AddIn is the problem.
This error also occurs if you have recently upgraded or saved an Excel file that was created between versions to a different location.
To fix this issue you can run the following (no guarantees :):
Select the file that was incorrectly saved in Excel
Press Alt + F11 to get into the Visual Basic Editor file.
From the Tools menu choose References
Scroll down to Available References Enable and disable anything that starts with MISSING:
Press Alt + Q when all reference errors have been disabled.
Hope I could help you with these information / link.
I know I don't know anything (Socrates)