Pictures in Cells - Protecting?

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
 
B

Bernie Deitrick

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top