现在我知道有一个 简单的解决方法 锁定和密码保护 VBA 代码的标准方式，我想继续使用更有效的代码保护方式.我要向客户提供一个基于 Excel 的工具，但我想要的不仅仅是简单的烦恼类型的保护，它只会阻止最懒惰的黑客.

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.

Excel-VBA 中是否有任何选项，或者我们真的必须编译一个单独的应用程序而忘记我们基于 Excel 的界面?

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

推荐答案

最简单、最有效的方法是将您的 VBA 代码移动到 VB6 编译的 Com/automation 插件.

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

或者，如果性能不重要，您可能需要考虑使用 .Net(带有混淆器)解决方案.

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