Adding a picture?

slyde

New Member
Joined
Aug 27, 2006
Messages
20
Hi guys. I'm not sure excel will let me do what i am trying, but here goes.

I want to add a picture to a cell, that can be seen either thru a mousover of the cell, or as a clickable hyperlink to the cell.

Before anyone suggests that you CAN hyperlink to a picture file, here is my problem. Excel will record the path and pull the picture in dynamically. So, if i had a picture on C:\mypics\picturetest.jpg, and i had my excel sheet hyperlink to it, then whoever i gave the excel file to would need to have the pic in a local c:mypics\picturetest.jpg for the file to be seen.

I guess what i need is for some way to bundle the pics up with a worksheet, so whoever i give the spreadsheet to can see them.

All ideas are welcome. Thanks in advance!
 

Excel Facts

Can Excel fill bagel flavors?
You can teach Excel a new custom list. Type the list in cells, File, Options, Advanced, Edit Custom Lists, Import, OK

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
You could try a picture in a comment:


  • # Insert | Comment

    # Click on the Comment Box, Right Click on one of the Handles

    # Click on Format_Comment

    # Click on Colors and Lines Tab

    # Then from the Fill | Color DropDown, click on Fill_Effects

    # Click on the Picture Tab

    # Click on Select_Picture

    # Navigate to select your picture, select it

    # OK your way out
 

patrickmuldoon99

Active Member
Joined
Jun 27, 2006
Messages
345
Do you have access to a shared drive where you are doing this? You could always post those images on your shared volume, and everyone will be able to see the pics

Failing that, you could zip the excel file up with all the relevant pics and allow users to 'install' your spreadsheet (essentially extracting images and the file to a pre determined location on their computer)

HTH
 

slyde

New Member
Joined
Aug 27, 2006
Messages
20
vog:

Thanks so much. That is EXACTLY what i was hoping i could do. I will try this tonight when i get home and let you know if i had success. I didnt think that you could put a pic in a comment, but that was what i was hoping for.

patrick:
unfortunatly, i dont have access to a shared drive, which is what has made this issue such a sticky one for me.

thanks guys.
 

slyde

New Member
Joined
Aug 27, 2006
Messages
20
.

VOG,

Could you tell me what version of excell you are using?

Here at work i have excell 2000, and when i click FORMAT in the comment, i only have a COLOR dropdown, and it doesnt give me the options you are describing.
 

slyde

New Member
Joined
Aug 27, 2006
Messages
20
never mind. I'm an idiot :)

i just figured it out.

This is EXACTLY what i was looking to do. thanks so much!
 

Forum statistics

Threads
1,137,191
Messages
5,680,076
Members
419,879
Latest member
jzl

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top