Pictures in Cells - Protecting?

  • Thread starter Thread starter mommio2
  • Start date Start date
M

mommio2

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
 
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
 
Back
Top