Move photos but not resize

[mommio2]

Hello,
Can anyone tell me if there is a way to lock or protect photos in Excel
or Word where they can be moved but not resized? Thanks a bunch!
Mommio

 

[Gord Dibben]

If this is in connection with your "sliding pictures" post over in one of the
Excel news groups may I propose an alternative.

Leave the pictures in a fixed position and next to each picture have a Data
Validation dropdown list and let the students select the name from the list.

Achieve same effect.......match name to picture instead of sliding pictures
around to names.

You can leave the DV list Cells unlocked then protect the sheet so's pictures
cannot be moved or re-sized.

Locking pictures from resizing but allowing moving is not possible. The only
thing you could do is to restore to a set size after re-sizing took place.

A macro would be required.

Sub Reset_Shapes()
Dim sh As Shape
On Error GoTo whoops
For Each sh In ActiveSheet.Shapes
With Selection.ShapeRange
.LockAspectRatio = msoFalse
.Height = 72# ' 1"
.Width = 72# ' 1"
.Rotation = 0#
End With
Next sh
whoops:
MsgBox "You have not selected any picture(s)"
End Sub


Gord Dibben MS Excel MVP

 

[mommio2]

Wow, thanks! What a great idea! No one was answering me over there.
Appreciate it.
Mommio

 

[Gord Dibben]

I guess no one thought of reversing the process as I proposed.

I had seen your post a couple of days ago and passed over it due to time
constraints.

Sometimes in the Excel groups we get too narrowly focussed on the mechanics of
the questions and forget what results are wanted.

Posters always know what results they want but don't always know the best way to
achieve it.

In your case it is a teaching method for the toddlers.


Gord