There is a hyperlink formula on each row in column AD. How can I get a macro to go to column AD of the active row and open the link but do it in such a way that it can load any link from an active row? ActiveCell.Offset(0, 8).Range("A1").Select Workbooks.Open Filename:= _ "\\share\shop\WO 1234.xlsm" ActiveWindow.Visible = False Windows("WO 1234.xlsm").Visible = True

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Hyperlink on active row

Thread starter Papi
Start date Jan 14, 2014

Papi

Well-known Member

Jan 14, 2014

There is a hyperlink formula on each row in column AD. How can I get a macro to go to column AD of the active row and open the link but do it in such a way that it can load any link from an active row?

Code:

    ActiveCell.Offset(0, 8).Range("A1").Select
    Workbooks.Open Filename:= _
        "\\share\shop\WO 1234.xlsm"
    ActiveWindow.Visible = False
    Windows("WO 1234.xlsm").Visible = True