VBA Certificate Generator
In-houseGenerates self-signed code signing certificates for Excel / Word VBA macro projects.
- Main category
- System tools
- Cost
- See the official site for cost
- Licence type
- Licence not stated
- Platforms
- Windows
Getting and using it
- Current version
- v1.0.2 · Version date 2026-05-22
- Requirements
- Windows (PowerShell creates the certificate). Running the .exe needs no Python; running from source needs Python 3.9 or later and no third-party Python packages.
- Installation and permissions
- No installation: download the .exe and run it, or run run.bat / python create_vba_cert_gui.py. The certificate is created in the current user’s certificate store (CurrentUser\My).
- Example input and output
- Input: certificate name “VBA Code Signing Certificate 2026”, a password, 10 years. Output: a .pfx (with private key), a .cer (public certificate), a log .txt and optionally a password reminder file, all with the same name.
- Output location
- By default saved in a generated_certificates folder next to the program, with time-stamped names, so existing files are not overwritten. An option removes older certificates with the same name from the current user’s store.
- Does data leave your computer?
- The source code makes no network calls; the certificate is generated by PowerShell on your computer and files are written locally only.
- Licence status
- LICENSE_NOTE.txt in the repository says no licence has been selected. The source can be read, but no permission to copy, modify or redistribute is granted; contact the author for such uses.
- Version history
- Version tags v1.0.1 and v1.0.2 exist; the repository has no separate changelog file.
- Reporting problems
- Report problems to info@zirulab.org.
- From start to output
- Start the program and fill in certificate name, PFX password, validity in years and output folder.
- Click “Create Certificate”.
- In Excel press Alt + F11, choose Tools → Digital Signature in the VBA editor, select the new certificate and save the file.
- To make the same or other internal PCs trust it, import the generated .cer file.
- Known limitations
- It creates self-signed certificates for personal, test and internal use; they do not replace commercial code-signing certificates from a public CA.
- Never upload the .pfx or password file to GitHub or share them.
- Windows only.
Checked against the code repository on 2026-11-05.
Details
VBA Certificate Generator is a Windows GUI tool that generates self-signed code signing certificates for Excel and Word VBA macro projects. It suits signing VBA tools on a personal computer, trusted distribution of internal macro files and signing macro projects during testing.