Share via

Third party certification of Excel VBA Macros

GrantN 76 Reputation points
2022-11-02T00:45:05.453+00:00

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.

Developer technologies | Visual Basic for Applications
0 comments

Answer accepted by question author

Dillon Silzer 60,836 Reputation points Volunteer Moderator
2022-11-02T03:33:23.85+00:00

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.

Was this answer helpful?

1 person found this answer helpful.
0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Oskar Shon 49,331 Reputation points Volunteer Moderator
    2022-11-08T18:27:17.527+00:00

    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.

    ![258411-instalacja-certyfikatu-pl.png]1

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. John Korchok 232.2K Reputation points Volunteer Moderator
    2022-11-02T23:32:06.893+00:00

    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.

    Was this answer helpful?

    1 person found this answer helpful.

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.