bovender / XLToolbox

Daniel's XL Toolbox is an open-source add-in for Excel(R) that assists with scientific and technical data analysis and visualization.
https://www.xltoolbox.net
Apache License 2.0
55 stars 10 forks source link

Unhandled VBA exception in # #931

Open bovender opened 3 years ago

bovender commented 3 years ago

This issue was submitted by the add-in's exception handler.

Exception:

XLToolbox.Legacy.UnhandledLegacyException: Unhandled VBA exception in # ---> System.Runtime.InteropServices.COMException: Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and then choose to enable macros. For more information about enabling macros, click Help.
   at Microsoft.Office.Interop.Excel._Application.Run(Object Macro, Object Arg1, Object Arg2, Object Arg3, Object Arg4, Object Arg5, Object Arg6, Object Arg7, Object Arg8, Object Arg9, Object Arg10, Object Arg11, Object Arg12, Object Arg13, Object Arg14, Object Arg15, Object Arg16, Object Arg17, Object Arg18, Object Arg19, Object Arg20, Object Arg21, Object Arg22, Object Arg23, Object Arg24, Object Arg25, Object Arg26, Object Arg27, Object Arg28, Object Arg29, Object Arg30)
   at XLToolbox.Legacy.LegacyToolbox.RunCommand(Command command) in X:\Code\xltoolbox\NG\XLToolbox\Legacy\LegacyToolbox.cs:line 200
   --- End of inner exception stack trace ---
   at XLToolbox.Legacy.LegacyToolbox.RunCommand(Command command) in X:\Code\xltoolbox\NG\XLToolbox\Legacy\LegacyToolbox.cs:line 248
   at XLToolbox.Dispatcher.Execute(Command cmd) in X:\Code\xltoolbox\NG\XLToolbox\Dispatcher.cs:line 83

Message: Unhandled VBA exception in #

Inner exception:

System.Runtime.InteropServices.COMException (0x800A03EC): Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and then choose to enable macros. For more information about enabling macros, click Help.
   at Microsoft.Office.Interop.Excel._Application.Run(Object Macro, Object Arg1, Object Arg2, Object Arg3, Object Arg4, Object Arg5, Object Arg6, Object Arg7, Object Arg8, Object Arg9, Object Arg10, Object Arg11, Object Arg12, Object Arg13, Object Arg14, Object Arg15, Object Arg16, Object Arg17, Object Arg18, Object Arg19, Object Arg20, Object Arg21, Object Arg22, Object Arg23, Object Arg24, Object Arg25, Object Arg26, Object Arg27, Object Arg28, Object Arg29, Object Arg30)
   at XLToolbox.Legacy.LegacyToolbox.RunCommand(Command command) in X:\Code\xltoolbox\NG\XLToolbox\Legacy\LegacyToolbox.cs:line 200

Inner exception message: Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and then choose to enable macros. For more information about enabling macros, click Help.

Environment

Parameter Value
Version 7.3.4
OS Microsoft Windows NT 10.0.19041.0, 64-bit
Excel 365 (16.0.12527), 64-bit
CLR 4.0.30319.42000, 64-bit
VSTO runtime 10.0.60828
ClickOnce False
Bovender 0.18.0.0
FreeImage 3.18.0
Identifier a7c3229fd0967bdc0189edf731d93b1731064d391c0af6ef7ac52da83f21b756