ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   can I insert a picture so it comes up when I put curser over cell (https://www.excelbanter.com/excel-worksheet-functions/176924-can-i-insert-picture-so-comes-up-when-i-put-curser-over-cell.html)

Mo Morrill

can I insert a picture so it comes up when I put curser over cell
 
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

can I insert a picture so it comes up when I put curser over cell
 
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" <Mo wrote in message
...
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?




Mo Morrill[_2_]

can I insert a picture so it comes up when I put curser over c
 
I think that will do it! I am very gratefull!!!!!

"Ron Coderre" wrote:

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" <Mo wrote in message
...
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

can I insert a picture so it comes up when I put curser over c
 
I'm glad I could help!

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

Regards,

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


"Mo Morrill" wrote in message
...
I think that will do it! I am very gratefull!!!!!

"Ron Coderre" wrote:

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" <Mo wrote in message
...
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?







Mo Morrill[_2_]

can I insert a picture so it comes up when I put curser over c
 
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.

"Ron Coderre" wrote:

I'm glad I could help!

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

Regards,

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


"Mo Morrill" wrote in message
...
I think that will do it! I am very gratefull!!!!!

"Ron Coderre" wrote:

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" <Mo wrote in message
...
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?







Gord Dibben

can I insert a picture so it comes up when I put curser over c
 
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

On Sat, 16 Feb 2008 18:00:01 -0800, Mo Morrill
wrote:

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.

"Ron Coderre" wrote:

I'm glad I could help!

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

Regards,

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


"Mo Morrill" wrote in message
...
I think that will do it! I am very gratefull!!!!!

"Ron Coderre" wrote:

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" <Mo wrote in message
...
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?








Mo Morrill[_2_]

can I insert a picture so it comes up when I put curser over c
 
PERFECT!! Got it thank you VERY much!!!

"Gord Dibben" wrote:

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

On Sat, 16 Feb 2008 18:00:01 -0800, Mo Morrill
wrote:

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.

"Ron Coderre" wrote:

I'm glad I could help!

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

Regards,

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


"Mo Morrill" wrote in message
...
I think that will do it! I am very gratefull!!!!!

"Ron Coderre" wrote:

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" <Mo wrote in message
...
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?










All times are GMT +1. The time now is 03:26 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com