Pictures in Cells - Protecting?
 

Hello,
I teach elementary computers, and I often make my own online worksheets
for the kids. I am making an "ABC Order" sheet where I have pictures of
animals in one column and pictures of animal names (as opposed to just
typing the names in the cells) in another column. The kids will slide the
names into alphabetical order, then slide the picture of the animal next to
it.
My question is this; is there a way to "protect" or "lock" the pictures
so that the kids can move them but not accidentally resize them? I have
tried every combination of lock and protect I can find, but I still can't
get it to do exactly what I want.
Thanks so much for any help you can give me!

Mommio

Pictures in Cells - Protecting?
 

Mommia,

You could use the selection change event to return all pictures to their original size. It would
require using code: if you are interested in trying the technique, post back.

HTH,
Bernie
MS Excel MVP


"mommio2" wrote in message ...
Hello,
I teach elementary computers, and I often make my own online worksheets for the kids. I am
making an "ABC Order" sheet where I have pictures of animals in one column and pictures of animal
names (as opposed to just typing the names in the cells) in another column. The kids will slide
the names into alphabetical order, then slide the picture of the animal next to it.
My question is this; is there a way to "protect" or "lock" the pictures so that the kids can
move them but not accidentally resize them? I have tried every combination of lock and protect I
can find, but I still can't get it to do exactly what I want.
Thanks so much for any help you can give me!

Mommio