Link to named picture

[Jeff Vandehey]

Hello, I have a workbook with some words that I would like to link to
pictures on a different worksheet. I know you can easily link from cell to
cell by highlighting a cell, then do insert.....Name...Define. You can then
create a hyperlink to that defined name.

I have pictures inserted. With the picture highlighted, I go to
Insert....Name...Define. It lets me put in a name. When I go to link to it
on the hyperlink edit window, I do not see the named picture available to
link.

I can put a word above the picture, and just link to that word, but it
sometimes doesn't show the entire picture I am linking to. The cell with the
work will show, but the picture I am trying to highlight might have a slight
portion of it showing. This could be fixed if I was able to 'center' the
named cell on the center of the page. As it is now, it might be in the last
row, cutting off most of the photo.

Any ideas?

Thanks,
Jeff

 

[Jeff Vandehey]

After thinking more, it would be even better if I could insert a picture as
a comment. That way, when there is a mouseover, the picture will pop up
inside the comment. There is a PC version here, any ideas on a Mac?

http://blogs.officezealot.com/charles/archive/2004/09/27/3019.aspx

-Jeff

 

[Jim Gordon MVP]

Hi Jeff,

Comment boxes are a sort of text box. You can use the fill property to
put pictures into them.

By hand, insert a comment then double-click the frame around the
comment. On the "Colors and Lines" tab click the Fill > Color drop down
box. Choose Fill Effects. Click the Picture tab button. Click the Select
Picture button, then navigate to a picture file.

Using VBA you can use something like this:
Selection.ShapeRange.Fill.UserPicture "PB:Applications:Microsoft Office
2004:Cliparthotographs:j0144243.jpg"

The comment box behaves just as you said you want with the picture
appearing when you mouse over the comment indicator.

-Jim

 

[Jeff Vandehey]

Hi Jeff,

Comment boxes are a sort of text box. You can use the fill property to
put pictures into them.

By hand, insert a comment then double-click the frame around the
comment. On the "Colors and Lines" tab click the Fill > Color drop down
box. Choose Fill Effects. Click the Picture tab button. Click the Select
Picture button, then navigate to a picture file.

Using VBA you can use something like this:
Selection.ShapeRange.Fill.UserPicture "PB:Applications:Microsoft Office
2004:Cliparthotographs:j0144243.jpg"

The comment box behaves just as you said you want with the picture
appearing when you mouse over the comment indicator.

-Jim

That is brilliant! Thanks Jim!

-Jeff