I have an Excel worksheet with an image (logo). If I right-click on the picture and select Format Picture / Protection, the "Locked" checkbox is checked. I then protect the worksheet with a password.
我有一个带有图像(标志)的Excel工作表。如果我右键单击图片并选择Format picture / Protection，“锁定”复选框将被选中。然后，我用一个密码保护工作表。
Despite all of the above, the end user can still select and delete the image. Is there any way to prevent this?
尽管上面有这些，最终用户仍然可以选择和删除图像。有什么方法可以预防这种情况吗?
Update
更新
Indeed Edit Objects was unchecked.
的确，编辑对象没有选中。
The Worksheet.Protect method I am using has a number of optional parameters which control what the user can modify on a protected sheet. The majority of these are parameters named AllowXXX (e.g. AllowFormattingColumns) which default to False.
工作表。我正在使用的Protect方法有许多可选参数，这些参数控制用户可以在受保护的表上修改什么。其中大多数是名为AllowXXX(例如AllowFormattingColumns)的参数，它们默认为False。
The parameter DrawingObjects is an exception. This parameter defaults to False: to protect drawing objects it must be explicitly set to True.
参数drawingobject是一个例外。此参数默认为False:要保护绘图对象，必须显式地将其设置为True。
2 个解决方案
#1
5
Protecting the sheet works for me.
保护床单对我很有效。
Check that the option "Edit objects" (down the bottom of the list of things you can allow the user to do, in the protection dialog box) is NOT checked.
检查“编辑对象”选项(在保护对话框中，在允许用户做的事情列表的底部)没有被选中。
#2
0
Try protecting the WorkBOOK also.
也可以尝试保护工作簿。
Edit: Ugh -- that doesn't seem to work.
编辑:嗯，这似乎行不通。
I Googled up this very ugly solution: prevent an image from being deleted or replaced
我在谷歌上搜索了这个非常丑陋的解决方案:防止图像被删除或替换
#1
5
Protecting the sheet works for me.
保护床单对我很有效。
Check that the option "Edit objects" (down the bottom of the list of things you can allow the user to do, in the protection dialog box) is NOT checked.
检查“编辑对象”选项(在保护对话框中，在允许用户做的事情列表的底部)没有被选中。
#2
0
Try protecting the WorkBOOK also.
也可以尝试保护工作簿。
Edit: Ugh -- that doesn't seem to work.
编辑:嗯，这似乎行不通。
I Googled up this very ugly solution: prevent an image from being deleted or replaced
我在谷歌上搜索了这个非常丑陋的解决方案:防止图像被删除或替换