I know that VBA passwords can be hacked in just a few minutes. Is there ANY way to protect/hide VBA code? A different approach?
I have some clients ($$) for an Excel/VBA app but don't want them viewing, modifying or redistributing the code.
The best tricks are never published on a public board however if we want a really secured app - don´t us any spreadsheet-software at all!
That said, VB/VB-Net offer some solution where we fire up an XL-app and control most of the XL-app via VB/VB.Net.
Yes. i admit it a common problem...
The password protect is the only way I know.
I read here somewhere you could make your code into an EXE file.
I mean are we dealing with hackers here or office admins.
Even if they come to know your come it is ok, because the logic you use also to be understand by other. No one will have time to rewrite or break.
In vba you are been paid for your Logic, and service you give , not for code.
If you are earning on code you are on luck.
Yes a VBA module can be hacked fairly quickly and I am pretty good at it.
(I could acctualy sell you an addin that does it if I were that way inclined, but I never told you that OK).
The best way to deter or I guess confuse a hacker is to give them a password that then needs to be deciphered.
What does that mean??
Well for example lets say you have a password: "EgadsSpecialPassword"
If I were to hack the file with this password on the VBA code I would be looking to get a text feedback of the actual password (most hackers do).
So instead of giving them an easy to read text string as above try something different like putting in odd characters and my favorite SPACES, yes good old fashioned blank spaces can drive a hacker nuts.
Your special password may become:
"Egads Special_________________________________________ Pass word"
Give it a go but do remember to maintain the exact password in a seperate file or hardcopy somewhere. Forget how many spaces, underscores etc and your stuffed.
I had put a lot of spaces between the wording in the above example but this software has removed them.
I think you'll get the idea though.