How do make pictures in Excel full screen or larger when you click?

[eyespider]

Hi I had a spreadsheet with 17 photos on, one in each cell. I had to resize so you can see them all on the screen.
If you have some pictures that are resized to fit in cells, is there any way to double click (or hover?) them and make them actual size or full screen when you want to view them in detail?

thanks

[natefarm]

Pictures.xlsm

I think the attached will do what you want. Just single-click the pictures to see it work (remember to Enable Editing and Macros first). I was hoping for a way to assign all the pictures to the same macro, but couldn't find how to identify which one was clicked, so a separate subroutine will need to be defined for each. I started you off with two, so just copy & paste to get your 17 and adjust the names, then right-click each picture and assign the macro accordingly.

[eyespider]

Many thanks natefarm! Will try this at work tonight!

[mcneilj]

Attachment 289678

I think the attached will do what you want. Just single-click the pictures to see it work (remember to Enable Editing and Macros first). I was hoping for a way to assign all the pictures to the same macro, but couldn't find how to identify which one was clicked, so a separate subroutine will need to be defined for each. I started you off with two, so just copy & paste to get your 17 and adjust the names, then right-click each picture and assign the macro accordingly.

Hi, I am new to the forum. I have been searching how to do this as well but I don't think I have the background (extensive use) in order to accomplish this without a step by step. I want to produce a catalogue for my ceramic pieces and would like to be able to send the list with pictures that if you click on them they expand to the original size. Can you advise me how I go about doing this. I don't want to have full size pictures in the Price list - but want customers to be able to view full size.

Greatly appreciate any help I can get, trying to keep my budget for this a low as possible - free = me

cheers
Judy

[FDibbins]

Hi, I am new to the forum. I have been searching how to do this as well but I don't think I have the background (extensive use) in order to accomplish this without a step by step. I want to produce a catalogue for my ceramic pieces and would like to be able to send the list with pictures that if you click on them they expand to the original size. Can you advise me how I go about doing this. I don't want to have full size pictures in the Price list - but want customers to be able to view full size.

Greatly appreciate any help I can get, trying to keep my budget for this a low as possible - free = me

cheers
Judy

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread