Forum Discussion
Balachandra_NR
Nov 01, 2023Copper Contributor
Strategic recommendation of MS on the usage of VBA Macros in Office
Hi Team, As per the recent Microsoft security baselines, MS recommendation is to block VBA macros downloaded from Internet or network locations. Although we have sufficient documentation availabl...
JKPieterse
Nov 01, 2023Silver Contributor
Balachandra_NR I'm not liaised with Microsoft so this is not an official advice 🙂
Signing VBA code is of little help to ensure you can run VBA code, the "Mark of the Web" will still prevent the code from working if you downloaded the file or saved it from an email message.
I would say Office script combined with Power Automate is the way forward if it comes to "end user automation". For professional developers the way forward is probably office-js add-ins
Balachandra_NR
Nov 06, 2023Copper Contributor
Thank you for the response, it makes sense to explore power automate and office scripts further. Will feedback our business accordingly.
Thanks again 🙂