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
Sheet14.Unprotect password:=password
2. Clearing used range given name as "MyRange"
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
Bookmarks