Hi,
I have a shape in Excel that when clicked on fires of the following code:
Sub GetURL()
Dim NewURL As String
Dim FollowURL As String
NewURL = ThisWorkbook.Sheets("Category Review").Range("AP107").Value
ThisWorkbook.FollowHyperlink NewURL
End Sub
This code works fine...