The Ills of Protecting Code

It is possible to lock a VBA project so that it cannot be viewed. I do not recommend this at all. When code is protected and an error is encountered, your user is presented with an error message, but no opportunity to debug. The Debug button is there, but it is grayed out. This is useless in helping you discover the problem.

Further, the Excel VBA protection scheme is horribly easy to break. Programmers in Estonia offer $40 software that lets you unlock any project. So understand that office VBA code is not secure and get over it.

0 0

Post a comment