Trying to play with Pictures/Images...

[DMcCallister]

Is there a way to make it so an Image or Picture can be dragged to only certain spots on an Excel Sheet? I'd like it to go back to it's default location if the user missed the area to where it SHOULD/COULD be put. Let's say the Picture is currently "Snapped" into Cell G1. I want it to be "Snapped" into any Cell in Column C otherwise it goes back to G1.

[shg]

Not diectly; there's no event generated when a picture/shape is moved, so you'd need to test the location in the selection change event or calculate event, and then move it -- that wouldn't be real intuitive to the user.

[DMcCallister]

Not diectly; there's no event generated when a picture/shape is moved, so you'd need to test the location in the selection change event or calculate event, and then move it -- that wouldn't be real intuitive to the user.

Yea I figured as much I used some VBA to move the image(s). I decided to go with a Picture_Click Procedure instead of trying to figure out Drag and Drop stuff. I will end up just coding some constants in the background to mimic the "idea" but thanks for your time!

[shg]

You're welcome.