VBA password protection: how it works? is it secure? are there any alternatives?

By : axk
Source: Stackoverflow.com

In case one wants to protect VBA applications to make trial(demo) versions and not to expose the scripts, how secure the built in password protection is? Are there any alternatives?

Edit: I'm asking about Excel VBA here.

By : axk


Absolutelly argree with DaveParillo, security is quite poor even in 2010/13 version. The only way to protect your file is put password for openning wich uses real crypting (AES 128 bit), option "Encrypt Document" give the same result. All others:

By : lbeliarl

It is not secure. Anyone opening your document in OpenOffice will get immediate access to the code. Open office basically ignores any password protection.

The OO folks have a very good document describing the Excel file format. Section 4.18 (pg. 114) starts the discussion on how protection is handled. Onorio's suggestion on using an add-in will slow someone down, but will not stop a determined hacker.

It's sort of like locking the door to your house. It won't keep out someone determined to get in, but does 'keep honest people honest'.

If you really want to protect source, this may be the way to go for you. For those who may not want to follow the link it's an article regarding developing an XLL add-in for Excel 2007. Xll is a specialized dll for use with MS Excel.

This video can help you solving your question :)
By: admin