Thanks for the detailed explanation!

I’ve been thinking about how to handle deploying macros in an organization, especially with the rise of AI-generated code. Do you have any suggested workflows for rolling out new macros to multiple users?

I ask because I’ve seen cases where users rely on AI to generate VBA code, and while it’s great for quick solutions, it can also lead to security issues. For example, I once came across a Word macro that someone created using AI—it automatically searched selected text on Google. At first glance, it seemed harmless, but it ended up triggering antivirus alerts because it was flagged for potentially malicious behavior (turned out there was a trojan in the code).

So, I’m curious:

How do you balance the convenience of AI tools with the need for secure, reliable macros?

Do you have any tips for ensuring macros are safe before deploying them across an organization?

Looking forward to hearing your thoughts!