电子表格脚本访问 [英] Spreadsheet Script Access

问题描述

是否有可能禁止共享电子表格的用户查看/编辑对所包含脚本的访问权限，同时仍允许他们将脚本用作函数或宏？

解决方案

我认为文档的摘录回答了您的问题问题 -

对于容器绑定脚本，脚本的访问规则是
有点不同。绑定到容器
的脚本项目（例如Google Spreadsheet或Google Site）将继承容器的
权限。例如，如果[e-mail]具有
编辑Google电子表格的访问权限，则[e-mail]也会
能够查看和编辑绑定到该
的任何脚本注意：对于2012年6月8日之前创建的容器绑定脚本，
Share按钮将保留并且任何项目特定的共享设置$ b未选中该脚本的复选框允许文档协作者为
编辑项目或允许站点协作者和所有者编辑项目
时，$ b将被保留。在这种情况下，如果您点击共享
按钮，则会看到一个选项，以升级到上述这些项目的简化共享
模型。

Is it possible to prohibit users of shared spreadsheets view/edit access to the included scripts while still allowing them to use the script as a function or macro?

解决方案

I think that this excerpt from the documentation answers your question -

For container-bound scripts, the access rules for the scripts are a little bit different. A script project that is bound to a container, such as a Google Spreadsheet or Google Site, will inherit the permissions of the container. For example, if [e-mail] has edit access to a Google Spreadsheet, then [e-mail] will also be able to view and edit any scripts that are bound to that spreadsheet.

Note: For container-bound scripts created prior to June 8, 2012, the Share button will remain and any project-specific sharing settings will be preserved if the checkbox to "Allow document collaborators to edit project" or "Allow site collaborators and owners to edit project" was not selected for that script. In this case, if you click the Share button, you'll see an option to upgrade to the simplified sharing model described above for those projects.

这篇关于电子表格脚本访问的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！