Excel 2007 : Linking.

[pawnraider]

I would like to link a cell to an image I've converted to a picture (.jpg) but I don't want that pic showing up in the cell, just a link to it. Whenever I've tried to add the link a smaller picture shows up with the cell or IE opens up and then opens up the picture. Is there a way to link to the picture without all of these annoying extras? What I've done so far is cell-insert tab-object-create from file-browse-double click on .jpg-insert-tick link to file box-OK. Any suggestions?

[Andy Pope]

So just a link, no image to be displayed.

Did you try addin a hyperlink?

Right click cell, Hyperlink... browse for file.
The cell will display the path/filename. When clicked the image will loaded in the associated application

[pawnraider]

Whenever I do a hyperlink IE opens up and then displays the image. Is there anyway I can do this without IE opening up or am I outta luck?

[Andy Pope]

What did you want to happen when the link is clicked?

[pawnraider]

For the link to open the image or link directly without IE opening up or is this possible?

[Andy Pope]

Open the image with/in what application?
Should it insert the image into excel?

If it's another application you need to use windows to associate the extension with that app.

If you want to insert the image into the excel worksheet then you can code against the Worksheet_SelectionChange event

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
   MsgBox "Do something with " & Target.value
End Sub

[pawnraider]

I think I may have found out where the problem lies. I was trying the hyperlink on the home computer which uses Windows Vista which is where I have been having problems. I tried this on the computer at work which has Windows XP and it not only worked flawlessly but as I expected. If the problem is with Vista I wonder why it tries to open up IE as well?

[Andy Pope]

Check the application associated with the extension. Maybe Vista defaults to IE if nothing else is assigned.

[pawnraider]

How do I do that? Would the fact that I use AOL at home have anything to do with my problem as well?

[Andy Pope]

Not sure AOL has anything to do with it.

I'm sitting in from of XP at the moment but try right clicking a file with the correct extension and check the Open With... setting