Third party certification of Excel VBA Macros

Question

Hi. I am starting a new business that will distribute industry specific spreadsheets that sometimes might contain macros to run background processes. Is there a way to receive a third-party certification of these spreadsheets so they can always be run by the user, independent of security settings? Thanks.

Answer 1

Hi @GrantN

There is no way to circumvent a user's security settings. The user still would have to alter their settings to allow/disallow your spreadsheets:

Change macro security settings in Excel

https://support.microsoft.com/en-us/office/change-macro-security-settings-in-excel-a97c09d2-c082-46b8-b19f-e8621e8fe373

------------------------------------------

If this is helpful please accept answer.

Answer 2

Sorry, there's no third-party verification. But it can help if you buy a code-signing certificate and digitally sign your VBA code. Do a search on VBA code signing to find vendors. You can't use SSL certificates, or even generic code-signing certs from just any vendor, they have to specifically support VBA.

Answer 3

Generate your certificate using selfcert.exe (you can find it in your system). You cant move it to write to another machine, but you can get access to recipients.
Add it to your project. If someone want to use your solution, can add it to repository and run your files.

]1