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?
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
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?
What did you want to happen when the link is clicked?
For the link to open the image or link directly without IE opening up or is this possible?
Last edited by pawnraider; 08-30-2009 at 11:43 AM.
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
Please Login or Register to view this content.
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?
Last edited by pawnraider; 08-31-2009 at 07:23 PM.
Check the application associated with the extension. Maybe Vista defaults to IE if nothing else is assigned.
How do I do that? Would the fact that I use AOL at home have anything to do with my problem as well?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks