However, cyber-security specialists also run a risk of preventing progress in the name of security. Microsoft would not have gone to the effort or expense of building this functionality if it weren’t something users wanted.
This move also makes Excel more compatible with Google Sheets, so that porting scripts between the two becomes easier. That has its own obvious benefits, such as making offline development easier, making libraries portable between Excel and other spreadsheet apps, and giving people freedom to choose their environment.
I was glad to see that at least one other person also saw this a welcome addition. I can see why other security professionals see the down-sides, but if anything this will also make their skills more useful, so they should cheer up.
The security issues will need to be addressed, people may need to be made more aware, better tools and safety-nets need to be added. The attitude that “Users don’t need this” or “Users don’t understand and will create problems” certainly doesn’t help progress. The Users want it, it’s the job of engineers to provide it, in a way that reduces additional risk.