Hi everyone,

I have an excel spreadsheet that I share online with a variety of users. The excel spreadsheet is pretty complex and also includes some VBA. It seems like my VBA frequently triggers false positives from antiviruses as well as windows itself (which blocks all macros by default and send warning messages), creating issues to share the spreadsheet. Typical AV culprits are VirusTotal (a website that tests files through dozens of antivirus apps) and, more annoyingly, Gmail (which won't let me send the spreadsheet by email sometimes).

So I was wondering if there were any best practices I should follow when working on files with VBA? I can't remove the VBA itself because it's absolutely necessary to the spreadsheet, but maybe I can find and rework certain things that have a higher chance of triggering antiviruses.

On a related note, do you think paying for a digital certificate from a third party would help with building trust for the file and reducing issues when sharing it?

Thanks