Geek Answers Handbook

How to protect image on excel sheet

I have an Excel worksheet with an image (logo). If I right-click on the image and select "Image Format / Protection", check the "Locked" box. Then I password protect the worksheet.

Despite all of the above, the end user can still select and delete the image. Is there any way to prevent this?

Update

In fact, the editing objects are not marked.

The Worksheet.Protect method that I use has a number of optional parameters that control what the user can modify on the protected sheet. Most of them are parameters called AllowXXX (for example, AllowFormattingColumns), which default to False.

The DrawingObjects parameter is an exception. This parameter defaults to False: to protect drawing objects, it must be explicitly set to True.

+4
source share
2 answers

Sheet protection works for me.

Make sure that the “Edit objects” option (at the bottom of the list of things that you can allow the user in the protection dialog box) is NOT checked.

+5
source

Try also protecting WorkBOOK.

Edit: Ugh - this does not work.

I was looking for this very ugly solution: prevent image deletion or replacement

0
source

More articles:


All Articles