Home

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

%3CLINGO-SUB%20id%3D%22lingo-sub-392241%22%20slang%3D%22en-US%22%3EHow%20do%20you%20protect%20images%20from%20being%20moved%20in%20a%20protected%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392241%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20worksheet%20with%20multiple%20images%20inserted.%26nbsp%3B%20I%20have%20locked%20all%20cells%20except%20a%20few%20that%20I%20want%20to%20allow%20editing.%26nbsp%3B%20These%20cells%20are%20several%20columns%20away%20from%20the%20images%2C%20and%20there%20are%20no%20associations%20between%20the%20cells%20and%20the%20images.%26nbsp%3B%20After%20I%20protect%20the%20worksheet%2C%20I%20find%20that%20the%20images%20can%20be%20dragged%20around%20on%20the%20worksheet.%26nbsp%3B%20%26nbsp%3BIs%20there%20a%20way%20to%20lock%20the%20images%20so%20they%20cannot%20be%20modified%20or%20moved%20in%20a%20protected%20worksheet%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-392241%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393468%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20protect%20images%20from%20being%20moved%20in%20a%20protected%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393468%22%20slang%3D%22en-US%22%3E%3CP%3EGlad%20to%20hear%20that%20the%20problem%20has%20been%20solved!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F284322%22%20target%3D%22_blank%22%3E%40kardebar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-393351%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20protect%20images%20from%20being%20moved%20in%20a%20protected%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-393351%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20the%20reply.%26nbsp%3B%20As%20it%20turns%20out%2C%20the%20lock%20was%20checked%20on%20all%20my%20images%20already.%26nbsp%3B%20I%20finally%20figured%20out%20that%20when%20protecting%20the%20worksheet%2C%20examine%20the%20actions%20you%20will%20allow%20after%20it%20is%20protected.%26nbsp%3B%20Before%20entering%20a%20password%2C%20scroll%20to%20the%20very%20bottom%20and%20make%20sure%20the%20check%20is%20removed%20from%20%22edit%20objects%22.%26nbsp%3B%20Funny%20how%20I%20have%20read%20about%2030%20responses%20on%20how%20to%20protect%20those%20images%2C%20but%20none%20of%20them%20bother%20to%20explain%20the%20nuances%20of%20the%20protect%20worksheet%20function.%26nbsp%3B%20I%20also%20found%20that%20headers%20and%20footers%20are%20not%20protected%20by%20worksheet%20protection%20methods.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-392717%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20you%20protect%20images%20from%20being%20moved%20in%20a%20protected%20worksheet%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-392717%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20right-click%20the%20image%20and%20choose%20Size%20and%20Properties%2C%20then%20make%20sure%20that%20the%20Locked%20checkbox%20is%20checked.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F101289i24CC0D568483730E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Lock%20an%20image%20in%20Excel.png%22%20title%3D%22Lock%20an%20image%20in%20Excel.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F284322%22%20target%3D%22_blank%22%3E%40kardebar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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
Highlighted

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
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies