View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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