Image linking

Last Edited By Krjb Donovan
Last Updated: Mar 05, 2014 09:42 PM GMT

Question

Is it possible to insert a photo file and make it transparent so that you can utilize the cells under the photo to set as links to other files? In other words...I have a diagram that i imported intoas a jpg file...the diagram is of a house I want to draw arrows and label "photo 1" etc and hyperlink so that when you click on the part of the diagram it opens up to the hyperlink in thefile displaying the photo on another sheet in the same workbook. The problem I'm having is that I can't getto recognize parts of the photo it will let me go over the photo file with a txt box but I cannot plug in a hyperlink or formula bc i cannot get to the actual cell...

Answer

Jonathan

I think you would be better off triggering your hyperlink from a control, like a text box, or an image control, or label, an arrow, or something else. You could position them over your picture, and have the "click event" for the control trigger the hyperlink.

For example, if you inserted an arrow on top of you picture, the click event code for the arrow could look like:

Sub StraightArrowConnector3_Click()

  Range("A2").Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True

End Sub

if your desired hyperlink were in cell A2.

Advertisement

©2017 eLuminary LLC. All rights reserved.