So my Excel-VBA project password can easily be cracked... What are other options?

Question

Now that I know that there is an easy workaround to the standard way of locking and password-protecting VBA code, I'd like to move on to more effective ways of protecting code. I am to deliver an Excel-based tool to a client, but would like something more than simple annoyance-type protection that will only deter the laziest of hackers.

Are there any options in Excel-VBA, or do we really have to compile a separate application and forget about our Excel-based interface?

Answer 1

The easiest and most efficient way is to move your VBA code to a VB6 compiled Com/automation addin.

Or you may want to consider a .Net (with obfuscator) solution if performance is not important.

Answer 2

Another Trick is to write the code against a excel object in Access then make the access file in to a .mde http://www.blog.methodsinexcel.co.uk/?s=Access+MDB Poor, but cheep ;-)