Enlarge small Pictures with a click (assign a Macro to a picture)

Hello,

What I would like to have:
I have a table, where in every row - next to the information - there is picture that helps descripe the situation better.
The pictures can be quite large (up to 1000x1500 px) so I want to make them fit in a 50x50 cell by manually reducing their size (not the file size or resolution, just a thumbnail)

So, to make them big again (not necessarily original size , just bigger), I've found a macro that does just that - and it places the picture on top.

Please Login or Register  to view this content.

The problem I have with it;
If I have multiple picture, I would assign the same macro to them all.
But, if I want to enlarge another picture afterwards (while the first one stays big), the macro instead of enlarging it, makes it even smaller (that is probably logical as the macro does that).

So, is there a way around? How can I achieve the "enlarge just pictures that are small and make small just the ones that are large"?
The macro should be some kind of a loop... enlarge/make small - from the inserted original size to the manually created "thumbnail" size.

Any comments or suggestions would be welcomed.
Thanks.

No suggestions? Any at all?
Would really appreciate your help, as this would save me a lot of stress in my daily excel work.

Hi Andy,
thank you very much, this works great. Even better then I first imagined

Just one more question; can I somehow replace the definition by how much (e.g. -50, + 50) with "enlarge to original" and make small to predefined (by how much I manually made it small)?