Adding a hyperlink to a picture in Excel 2007

K

Kristian

I am using Windows XP and Excel 2007. Prior to my upgrade from Excel 2003 I
had numerous worksheets with a company logo pasted onto graphs. Users
viewing the workbook could click on the logo to return to the frontpage.
These were created using hyperlinks. In Excel 2007 I use the same procedure.
I paste the picture onto the worksheet and right-click to edit the
hyperlink, but it is no longer a valid option. I can't select Edit Hyperlink
anylonger. Any tips? Can it be that MS has removed these feature from Excel
2007? No more hyperlinks on pictures?
 
J

Jim Rech

I had no problem doing this in Excel 2007. I inserted a picture, right
clicked it and picked Hyperlink. Then I selected "Place in this document"
from the Insert Hyperlink dialog and picked Sheet1.

--
Jim
|I am using Windows XP and Excel 2007. Prior to my upgrade from Excel 2003
I
| had numerous worksheets with a company logo pasted onto graphs. Users
| viewing the workbook could click on the logo to return to the frontpage.
| These were created using hyperlinks. In Excel 2007 I use the same
procedure.
| I paste the picture onto the worksheet and right-click to edit the
| hyperlink, but it is no longer a valid option. I can't select Edit
Hyperlink
| anylonger. Any tips? Can it be that MS has removed these feature from
Excel
| 2007? No more hyperlinks on pictures?
 
K

Kristian

Jim,

Does this work in a graph worksheet? I have a graph's location as an entire
worksheet and this isn't working for me in Excel 2007.
 
J

Jim Rech

When I try this with a Chart sheet the hyperlink option is grayed out, as
you said. Furthermore if I open an Excel 2003 workbook with a chart sheet
with a picture with a hyperlink, the hyperlink does not work. So for
whatever reason MS has disabled this. It seems all you can do is attach a
macro that selects the sheet to the picture.

--
Jim
| Jim,
|
| Does this work in a graph worksheet? I have a graph's location as an
entire
| worksheet and this isn't working for me in Excel 2007.
|
| "Jim Rech" wrote:
|
| > I had no problem doing this in Excel 2007. I inserted a picture, right
| > clicked it and picked Hyperlink. Then I selected "Place in this
document"
| > from the Insert Hyperlink dialog and picked Sheet1.
| >
| > --
| > Jim
| > | > |I am using Windows XP and Excel 2007. Prior to my upgrade from Excel
2003
| > I
| > | had numerous worksheets with a company logo pasted onto graphs. Users
| > | viewing the workbook could click on the logo to return to the
frontpage.
| > | These were created using hyperlinks. In Excel 2007 I use the same
| > procedure.
| > | I paste the picture onto the worksheet and right-click to edit the
| > | hyperlink, but it is no longer a valid option. I can't select Edit
| > Hyperlink
| > | anylonger. Any tips? Can it be that MS has removed these feature
from
| > Excel
| > | 2007? No more hyperlinks on pictures?
| >
| >
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top