Apr 01 2019 03:32 PM
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?
Apr 01 2019 08:14 PM
SolutionHi,
Please right-click the image and choose Size and Properties, then make sure that the Locked checkbox is checked.
Hope that helps
Apr 02 2019 02:36 PM
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.
Apr 02 2019 07:43 PM
Jul 11 2022 10:11 AM
@kardebar Thank you. Even though this post is 3 years old it provided some very useful information.