Support – Compile in Hidden Module frmGetRange

Compile Error in Hidden Module frmGetRange

Error in frmGetRange

When using any tool in Quantum XL, SPC XL, or DOE Pro that uses Excel’s refEdit control, the user receives an error starting with “Compile error in hidden module: frmGetRange”

Solution – Disable Safe Mode in ActiveX Settings 

Please consult your IT department before making these changes
  • From Excel select “File” then “Options” (Options is in the lower left corner)

  • Click the “Trust Center Settings” Button

  • Select “ActiveX Settings”

  • Select “Prompt me before enabling Unsafe for Initialization (UFI) controls with additional restrictions for Safe For Initialization (SFI) controls with minimal restrictions” (preferred) OR if that doesn’t work “Prompt me before enabling all controls with minimal restrictions”

  • Uncheck “Safe mode (helps limit the contro’s access to your computer”

ActiveX_PromptBeforUFI
ActiveXSafeMode