Lock Picture Only - When unlock sheet temporary for clear

Hi,

In my coding, I am clearing used range with Clear function. (I do not want to use clearcontens)
In Used range in center I have picture. (Name Picture 1).

My problem,
1. I am unlocking sheet with using code , code set with function properly

Please Login or Register  to view this content.

2. Clearing used range given name as "MyRange"

Please Login or Register  to view this content.

This creates problem that cells cleared having format Lock cells, if I lock sheet again to protect picture from delete then my sheet affects in used range to locked cells. (I do not want to use clearcontents)

3. Main thing requires, I want that picture 1 should be locked, which can't be deleted or moved at any reasons while following above codes.

Thanks for your time.

Regards, RR1050

try this :

Please Login or Register  to view this content.

it selects only unlocked cells
you can add to this :

Please Login or Register  to view this content.

or just make the above

Please Login or Register  to view this content.

I have not tested this, so my apologies in advance if this does not work 100%

Thanks for your time.

Yes I like your thoughts.....