Skip to main content

VBA Certificate Generator

In-house

Generates 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
  1. Start the program and fill in certificate name, PFX password, validity in years and output folder.
  2. Click “Create Certificate”.
  3. In Excel press Alt + F11, choose Tools → Digital Signature in the VBA editor, select the new certificate and save the file.
  4. 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.