如何保护共享工作簿中的工作表? [英] How to protect a Worksheet in a Shared Workbook?

问题描述

我有一个工作簿，将在多个用户之间共享.将运行一个宏，以从Excel表单中的用户窗体输入数据.

I have a workbook which will be shared among multiple users. A macro will be run to enter data from userform in the Excel sheet.

该工作表需要受到保护，以便用户无法对其进行编辑.

The sheet needs to be protected so users can't edit it.

我有ws.Unprotect

I had ws.Unprotect

我的宏代码

ws.Protect UserInterfaceOnly:=True

共享工作簿时，它将显示以下错误:

When the workbook is shared it shows the following error:

运行时错误1004方法'保护对象'_worksheet'失败

runtime error 1004 method ' protect of object '_worksheet' failed

推荐答案

共享的工作簿/工作表有局限性...在此处检查..

Shared Workbooks/Worksheets have limitations... check here.. https://support.office.com/en-us/article/Use-a-shared-workbook-to-collaborate-49b833c0-873b-48d8-8bf2-c1c59a628534

这篇关于如何保护共享工作簿中的工作表?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！