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?
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.