View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Can't open picture file link in Excel, Error no program registere.

I right click mouse on cell I wanted to add hyperlink. Then selected
Hyperlink and sel;ected the file I wanted to add.

I also did this using a recorded macro and got the following code
Sub Macro1()
ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
"C:\TEMP\Ferry 2.jpg", TextToDisplay:="C:\TEMP\Ferry 2.jpg"
End Sub




"Habanero Mike" wrote:

How can I open my Kodak pictures in a hyper linked fashion in Excel? I tried
this but I get an error of: "no program is registered to open this file" I
could probably change the "open with" in windows explorer but... this would
change for every picture I open up on my computer which I do not want to do.

Can anyone help me out there?

Thanks,
Mike


Can anyone help me out there?

Thanks,
Mike