The reason for the switch is Microsoft announcing that they would end the massive abuse of the Office subsystem by automatically blocking macros by default and making it harder to activate them.

Excel macros are powerful automation tools that streamline repetitive tasks and boost productivity. As you create macros to automate your work processes, you may need to share them with your ...