can I insert a picture so it comes up when I put curser over cell

[Mo Morrill]

I am making a spread sheet where I want to put a name of a person in a cell.
Then I want to make it so when I put the curser over the cell or click on the
cell it brings up a picture of that person. Can this be done? How?

 

[Ron Coderre]

Try the method described at Debra Dalgleish's website:
http://www.contextures.com/xlcomments02.html#Picture

It creates comments that display the picture, instead of text.
If you have many to create, post back. There are other options.

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Mo Morrill]

I think that will do it! I am very gratefull!!!!!

 

[Ron Coderre]

I'm glad I could help!

--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

 

[Mo Morrill]

Okay, I do appreciate the help and you got me closer than I have been able to
for a solution but I have an issue. When I follow the directions it says to
go to format comment I can do that but then it says to click on the colours
and lines tab but the only tab I have is for font. I am using Excel for Mac
so I don't know if that is the issue.

 

[Gord Dibben]

Right-Click on the perimeter border of the Comment, not on the body of of the
Comment.

Many more options will be seen.


Gord Dibben MS Excel MVP

 

[Mo Morrill]

PERFECT!! Got it thank you VERY much!!!

Right-Click on the perimeter border of the Comment, not on the body of of the
Comment.

Many more options will be seen.


Gord Dibben MS Excel MVP