Home

How do you protect images from being moved in a protected worksheet

Highlighted
kardebar
New Contributor

I have a worksheet with multiple images inserted.  I have locked all cells except a few that I want to allow editing.  These cells are several columns away from the images, and there are no associations between the cells and the images.  After I protect the worksheet, I find that the images can be dragged around on the worksheet.   Is there a way to lock the images so they cannot be modified or moved in a protected worksheet?

3 Replies

Hi,

 

Please right-click the image and choose Size and Properties, then make sure that the Locked checkbox is checked.

Lock an image in Excel.png

 

 

@kardebar 

 

Hope that helps

 

Thanks for the reply.  As it turns out, the lock was checked on all my images already.  I finally figured out that when protecting the worksheet, examine the actions you will allow after it is protected.  Before entering a password, scroll to the very bottom and make sure the check is removed from "edit objects".  Funny how I have read about 30 responses on how to protect those images, but none of them bother to explain the nuances of the protect worksheet function.  I also found that headers and footers are not protected by worksheet protection methods.

 

@Haytham Amairah 

Glad to hear that the problem has been solved!

 

@kardebar 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
7 Replies