版权协议以打开Excel工作簿 [英] Copyright agreement to open an Excel workbook

问题描述

问候，

我很难完成涉及非技术人员的任务.

我的问题是这个；我的任务是为他要共享的Excel工作簿创建类似于版权保护的操作，但是他希望他们同意不共享"其中的信息.如果他们不同意，那么他不希望他们打开它.

我考虑过使用可以从网络目录调用Excel工作表的脚本，但是我们在传递可执行文件方面受到限制，并且有些人不在我们的Intranet中.

可以使用工作簿通过宏完成此操作吗?这甚至有可能实现，因为甚至CodeProject的Archives和文章/Google/Technet/和我的母亲似乎都没有引导我，只是使我摸不着头脑.

其他想法是使用HTML，但我认为他希望他们能够更改一些结果以查看公式是否正确运行，而我的HTML类似于三啄嘴的比利山羊的运行能力...

谢谢您的时间，

Steve

Greetings,

I''m having a difficult time trying to accomplish a task that involves non techfriendly individuals.

My issue is this; I was tasked to create an action similar to that of copyright protection for an Excel workbook that he wants to share, but he wants them to agree to "not sharing" the information located within. If they do not agree then he doesn''t want them to open it.

I considered using scripts that would call the Excel sheet from a network directory, but we have restrictions on passing around executable files, and some of the people are not located in our intranet.

Can this be accomplished using a workbook via macros? Is this even possible, as even CodeProject''s Archives and articles/Google/Technet/ and my mother didn''t appear to lead me anywhere but into a face palm?

Mt other thought was using HTML, but I think that he wants them to be able to change some of results to see if the formulas work correctly, and my HTML is akin to the running ability of a 3-peckered billy goat...

Thank you for your time,

Steve

推荐答案

我的建议是添加一个Auto_open VBA宏，该宏以对话框的形式提供版权声明.然后，用户可以选择单击Accept或Reject，如果不是Accept，则宏将自动关闭工作表.当然，这不是万无一失的，但至少足以使诚实的人考虑他们的行为.

My suggestion would be to add a Auto_open VBA macro which offers the copyright notice as a dialog. The user then has the choice to click on Accept or Reject, and if not Accept the macro automatically closes the worksheet. Of course, this is not foolproof, but it is at least good enough to make honest people consider their actions.

这篇关于版权协议以打开Excel工作簿的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！