1. Help center
  2. Frequently Asked Questions - FAQ
  3. Microsoft Excel

Compile error in hidden module

Avatar
Mohamad
Follow

Question:

Whenever I click an icon on the NumXL Toolbar, I receive a "compile error in hidden module" message, and nothing happens. I have uninstalled and reinstalled the NumXL program multiple times, but I still can’t figure out why this message keeps appearing.

Microsoft Visual Basic for Application: Compile error in hidden module

Answer:

Microsoft turned off all ActiveX components in Excel in the later office updates, rendering the refedit control (used in NumXL Wizards and Forms) disabled.

To re-enable ActiveX controls in Microsoft Excel:

  1. navigate to File → Options → Trust Center → Trust Center Settings → ActiveX Settings.

    2. Select Trust Center (sidebar) then click on the trust center settings

  2. Change the "disable all controls" option to another setting. For security reasons, we recommend selecting "Prompt me before enabling Unsafe Initialization (UFI) controls with additional restrictions and Safe for Initialization (SFI) control with minimal restrictions."

    3. Change the 'disable all controls' option to another setting, e.g., 'Prompt me before enabling Unsafe Initialization (UFI) controls with additional restrictions and Safe for Initialization (SFI) control with minimal restrictions'

Thank you for being a valued part of our community!

Related articles

Comments

Article is closed for comments.

Was this article helpful?
0 out of 0 found this helpful