Protecting VBA code

[DrBowes]

Hello all.

I have previously password protected code using the VBA Project properties. However this is not particularly secure as the password can be attacked by running every combination through it, and there are of course the companies on the internet that specialise in password breaking.

However I have seen VBA projects in Excel where it says "Project is unviewable". In some cases you can view all the sheets and modules in the project but not open the code windows for them. I guess those that have done this have done something similar to creating a MDE database, in that there is no way of viewing the code from that particular version of the spreadsheet.

Does anybody know how this was done, or any more about this.

Many thanks

DrB

 

[Chattin]

How about making your VBA Project into an add-in? Just an idea

HTH

 

[combo]

Unviewable project is also not secure. This message is for shared workbooks and, AFAIK, for old password protected modules. Both are easy to crack.

combo

 

[Channah]

I need to crack a sheet that a former employee locked down... how would I go about this?