禁止访问 Mac Office 中的 Visual Basic 编辑器
我一直在间歇性地为客户制作 Excel 电子表格，进行一些相当密集的计算。我们使用 VBA 实现了一个安全程序...起初，要求相对简单，并且讨论并很好地理解了电子表格中总体缺乏安全性的问题。
从那时起，客户决定希望纸张更安全一些。在正常情况下，我只需通过代码禁用开发人员菜单。不幸的是，我最近才发现该客户以及他的许多客户都在使用 Mac Office。 （有一些客户甚至在使用 2008，他们发现 2008 停止支持 VBA）
我的问题是；是否可以在 2008 年之前的版本、2011 年及之后的版本中禁用对 Mac Office 中 Visual Basic 编辑器的访问，因为根据我迄今为止所做的研究，Mac Office 将于 2011 年恢复 VBA 支持。
不幸的是，我这样做无法访问 Mac Office 版本，甚至无法真正查看应用程序和/或测试不同的解决方案。在 Windows 中，可以右键单击 VBA 项目，然后从 VBAProject 属性中选择保护，然后选择“锁定项目以供查看”。此选项是否存在并且在 Mac Office 中有效吗？
任何帮助/建议将不胜感激。
I've been working intermittently on an Excel spreadsheet for a customer that does some pretty intense calculations. We implemented a security procedure using VBA... At first the requirements were relatively simple, and the overall lack of security in a spreadsheet was discussed and well understood.
Since then the customer has decided that he would like to have the sheet a bit more secure. Under normal circumstances I would simply disable the developer menu via code. Unfortunately I just recently found out that the customer, and many of his customers, are using Mac Office. (There are some customers that are even using 2008 and they found out the hard way that 2008 stopped supporting VBA)
My question is; is it possible to disable access to the Visual Basic editor in Mac Office in versions Pre 2008, and versions 2011 and after since from the research I've done so far points to a return of VBA support in Mac Office in 2011.
Unfortunately I do not have access to a Mac Office version to even really look through the application and or/test different solutions. In Windows it is possible to right click the VBA project and choose protection from the VBAProject Properties and choose "Lock project for viewing". Does this option exist and is it effective in Mac Office?
Any help/suggestions would be greatly appreciated.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我非常确定您可以像在 Windows 中一样在 Mac Office 中锁定项目。请记住，在一个 Excel 版本中锁定的项目无法使用其他版本解锁。因此，如果您的客户需要能够解锁，他们将需要使用您用于锁定它的同一版本的 Excel。
I'm pretty sure you can lock projects in Mac Office the same way you can in Windows. Keep in mind that a project that has been locked in one version of Excel cannot be unlocked with a different version. So, if your customer needs to be able to unlock, they will need to use the same version of Excel you used to lock it.