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”