Code Signing

One way to prevent users from accidentally changing your macro project and invalidating your signature is to lock the macro project before applying the signature.
Even if you have locked your macro project, another user may still be able to replace your signature with another signature.
Corporate administrators can also re-sign templates and add-ins to ensure that only approved content is run on company computers.

link - 

Apply a Signature to a VBA Project

Tools, Digital Signature
You will now have the option to choose a certificate to use as a code signing certificate for this project.
All valid certificates installed to your machine with code signing enabled will be displayed to you.
Choose the appropriate certificate from this list, then choose OK twice to apply this certificate to the project.

microsoft excel docs

Macro Security Settings

microsoft excel docs

Digital Signatures

more details

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited TopPrevNext