compile error in hidden module?

Hi Kathryn,

A “Compile Error in Hidden Module” is a security alert in Excel VBA. It usually occurs when the VBA code is incompatible with the version or architecture of the Excel application. When you attempt to run the code, this alert pops up.

In order to investigate further, could you please provide me some additional information:

1. What's the exact error text, including the module name? (e.g., "Compile error in hidden module: cpinterview")?
2. In the VBA editor (Alt+F11 > Tools > References), do they see any entry marked "MISSING:"?
3. Do they have any other Office add-ins, antivirus, or security software active that might block macros or COM add-ins?

Once I have a clearer understanding of your current situation, I’ll be happy to assist you with greater accuracy. Please feel free to share any additional details you believe are relevant. Screenshots are especially helpful and much appreciated.

In the meantime, you can try to unprotect the VBA Module:

• Enable the Developer tab:
  • Go to the File menu.
• • Select Options in the Overview Panel.
• • Choose the Customize Ribbon tab.
  • Check the Developer feature under Customize the Ribbon.
  • Click OK to close the Excel Options box.

• Navigate to the Developer tab and select Visual Basic under the Code section.

• Right-click on the hidden module and choose VBAProject Properties.

• In the VBAProject – Project Properties window, go to the Protection tab and remove the password.
• Press OK.

If you have any additional questions, please feel free to reach out. 

I'm looking forward to your reply.