Enable all macros (not recommended, potentially dangerous code can run) All macros run without confirmation. This setting makes your computer vulnerable to potentially malicious code.

Why are Excel macros a security risk?

In fact, exploitation from malicious macros is one of the top ways that organisations around the world are compromised today. Malicious macros can do almost anything that other malware can do to your system, including emulating ransomware, stealing data, and emailing itself out to your contacts.

Why are macros bad?

when defining macros for magic numbers, the compiler retains no type information for the defined values. This can cause compilation warnings (and errors) and confuse people debugging the code. when defining macros instead of functions, programmers using that code expect them to work like functions and they do not.