I have been searching on several forums to find a way to attach a DYNAMIC hyperlink to a shape or an image in Excel 2007.
I have find the following "solution" which worked for me in a NEW/clean workbook.
Sub Picture33_Click()
Worksheets(1).Range("B31").Hyperlinks(1).Follow NewWindow:=True
End Sub
BUT, when I copied this into the workbook, I already was working on, everytime I got an error in line 2.
Can somebody tell me what I should do to solve this ? Does it have something to do with the location I copied the code to (workbook instead of module) ? PLEASE HELP !
(the DYNAMIC hyperlink is located in cell B31 and should be activated when clicked on Picture33). I guess, since the hyperlink should be dynamic, the HYPERLINK function is not an alternative.
Bookmarks