锁定Microsoft Excel宏 [英] Lock down Microsoft Excel macro

问题描述

我花了一些时间编写一个可能会为很多公司带来价值的Excel宏。

I've spent some time writing an Excel Macro that is potentially worth money to a lot of companies.

如何锁定宏以防止人们看到来源/转发给其他人？

How can I lock down the macro to prevent people seeing the source / forwarding to other people?

谢谢

推荐答案

一个href =http://www.ozgrid.com/VBA/protect-vba-code.htm =noreferrer>保护/锁定Excel VBA代码：

Protect/Lock Excel VBA Code:

当我们编写VBA代码时，通常希望VBA宏代码
对最终用户不可见。这是为了保护您的智力
属性和/或阻止用户与您的代码混淆。只要知道
，Excel的保护能力远远不能被认为是
安全。 在
www。

When we write VBA code it is often desired to have the VBA Macro code not visible to end-users. This is to protect your intellectual property and/or stop users messing about with your code. Just be aware that Excel's protection ability is far from what would be considered secure. There are also many VBA Password Recovery [tools] for sale on the www.

还有许多VBA密码恢复[工具]出售要保护您的代码，请打开Excel工作簿并转到
工具>宏> Visual Basic编辑器（Alt + F11）。现在，从VBE内的
到工具> VBAProject属性，然后单击保护页选项卡
然后检查锁定项目从查看，然后输入您的
密码，再次确认。这样做后，你必须保存，
关闭&重新打开工作簿以使保护生效。

To protect your code, open the Excel Workbook and go to Tools>Macro>Visual Basic Editor (Alt+F11). Now, from within the VBE go to Tools>VBAProject Properties and then click the Protection page tab and then check "Lock project from viewing" and then enter your password and again to confirm it. After doing this you must save, close & reopen the Workbook for the protection to take effect.

（重点是我的）

好像你最好的赌注它不会阻止人们决定窃取您的代码，但足以阻止休闲海盗。

Seems like your best bet. It won't stop people determined to steal your code but it's enough to stop casual pirates.

记住，即使您能够分发您的代码的编译副本'没有什么可以阻止人们反编译它。

Remember, even if you were able to distribute a compiled copy of your code there'd be nothing to stop people decompiling it.

这篇关于锁定Microsoft Excel宏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！