How to Use Compiled Vba in Excel
I Wrote Some Vba Code and Want to Hide It. I Know About the Password Protect Stuff, but I Found It Very Unelegant. Instead, Opted for Code Compilation. These...
I wrote some vba code and want to hide it. I know about the password protect stuff, but I found it very unelegant. Instead, opted for code compilation. These are the steps I'm following
1 - open excel
2 - right click on the sheet tab
3 - view source code
4 - write a sub in vb editor
5 - debug / compile vba project
No errors everything's fine
Now, the question is: how do I use the compiled code? Does excel generate something analog to a .jar?
1 Answer
From your perspective, the Compile VBA Code command essentially just does a syntax check for you. It's no different than what happens when you run your VBA project -- it first does a syntax check, reporting any errors that it may find, and then "compiles" your code into an intermediary byte code that is then executed. So you can't remove your Module, Class, or Form objects and have it use a "compiled" version of your project.
If you want to hide your VBA code from prying eyes, lock your project with a password.
Sophia analyzes international trade, startup ecosystems, retail transformation, and supply chain logistics for modern digital publications.
