Share via

Does anyone know how to open multiple hytper links in excel at once?

Anonymous
2017-05-30T03:51:29+00:00

I'm specifically trying to open them up in tabs. But I don't specifically know where to ask this question so I decided to ask it here.

Microsoft 365 and Office | Excel | For business | Other

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2017-05-30T09:22:30+00:00

    Hi Steve,

    We can achieve this by using VBA:

    1. Right click the sheet name > View Code.
    2. Paste the following code:

    Sub OpenHyperLinks()

    Dim xHyperlink As Hyperlink

    Dim WorkRng As Range

    On Error Resume Next

    xTitleId = "OpenHyperlinksInExcel"

    **Set WorkRng = Application.**Selection

    Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)

    For Each xHyperlink In WorkRng.Hyperlinks

    xHyperlink.Follow

    Next

    End Sub

    1. Click the Save button, save it as .xlsm file.
    2. Back to the sheet, select the cells which contain the hyperlinks (you may need to press the Shift or Ctrl key when selecting the cells), right click the sheet name > View Code > press F5, click OK.

    Regards,

    James

    40+ people found this answer helpful.
    0 comments
  2. Anonymous
    2017-05-31T12:39:56+00:00

    Hi Steve,

    Have you tried the above? Let me know if you need more help.

    Regards,

    James

    10+ people found this answer helpful.
    0 comments