# HOW TO IMAGE LOCK IN EXCEL SHEET ??? VBA ....

[krunal123]

I was try image fix in particular area .... image never move & resize ......how to possible vba code , pleased let me show ......
i can't try .......this query i'm not solve.....

Help me !!!

EXCEL 365 OR EXCEL 2016

 

[GlennJ]

you can right click the point in the first screen shot and click on Format Cells. click the protection tab and make sure all cells are not locked. Screen shot 2-Then go to the review tab and click protect sheet. Make sure the only box with a check mark is Select Unlocked Cells. This will lock the photo and still let you use the cells.

 

[bigbraincantoo03]

Not exactly sure what you mean, but it sounds like you don't want to change your picture dimensions when resizing rows or columns. Quick way to do this is to right click the image, chart, etc. and select 'Format Picture'. I have Excel 2016 so it's the third option for me so I just select 'Don't move or size with cells' and problem solved. Hope this helps.

 

[krunal123]

Not exactly sure what you mean, but it sounds like you don't want to change your picture dimensions when resizing rows or columns. Quick way to do this is to right click the image, chart, etc. and select 'Format Picture'. I have Excel 2016 so it's the third option for me so I just select 'Don't move or size with cells' and problem solved. Hope this helps.
View attachment 25395

NOT Working....
After used this trick to move image every where

 

[krunal123]

you can right click the point in the first screen shot and click on Format Cells. click the protection tab and make sure all cells are not locked. Screen shot 2-Then go to the review tab and click protect sheet. Make sure the only box with a check mark is Select Unlocked Cells. This will lock the photo and still let you use the cells.

So Amazing Tricks