Compile error in hidden module: Sheet3 when running the Wigglechart

/

Microsoft’s recent update to Excel disables all ActiveX controls with notification. As the Wigglechart relies on ActiveX controls, when running the Wigglechart, you will get this error message.


To fix this, follow these steps:

  1. Kill the Wigglechart background Excel process by:

    • Bring up the Windows Task Manager

    • Under Background processes, kill all “Microsoft Excel” processes (don’t worry, this will not affect any open Excel files)

  2. Open Excel

  3. File > Options > Trust Center > Trust Center Settings…

    • Set ActiveX settings to "Prompt me before enabling all controls with minimal restrictions”

    • Set Macro Settings to “Disable VBA macros with notification”

  4. Run the Wigglechart again