Encrypting Macros: is there a way to protect code other than using Unviewable + ?

[superlative]

Hi there,

I came across this page for encryption:
http://programandonet.com/questions/...denas-en-excel

In the suggestion entitled "This code works well for me (3DES Encryption / Decryption): "

there is a statement:
"I save INITIALIZATION_VECTOR and TRIPLE_DES_KEY as environment variables (obviously different values ​​from those published here) and I get them using the VBA Environ () function, so all the confidential data (passwords) in VBA code are encrypted."

It seems to imply that by stating encryption keys as environment variables, it will allow them to be "encrypted" so no one could see these keys. I don't understand what this means, because as far as I know if you declare a encryption key constant in Module1, everyone who can access the VBA can see that encryption key.

My goal is to protect my VBA code from being seen. Is the link above describing a way to do that? Or am I stuck using tools like Unviewable + ?

Thanks!!!

[Kyle123]

No, that's not what the page is describing. It's talking about how to do encryption as far as I can see, not encrypt the code in your workbook.

I've yet to see a solution for hiding/making VBA code unviewable without wrapping it in an exe that isn't trivial to bypass (ie without using standard software) - that includes Unviewable+

[superlative]

But you think Unviewable is a satisfactory solution? Thanks. I'm about to pull the trigger on it and need to make sure.

My code has really good encryption, user login etc. but all of it is null and void if the VBA is viewable since the encryption algorithms and keys would be visible. Thanks!

[Kyle123]

I think it's pretty easy to bypass, my honest opinion is that if you need security; you shouldn't be using Excel