How to Open Multiple Hyperlinks at Once in Excel

This post will guide you how to open multiple links at once in Excel. How do I open multiple Hyperlinks with VBA Macro in Excel.

Open Multiple Links at Once


Assuming that you have a list of data which contain multiple hyperlinks and you want to open those links at once in your current worksheet. How to do it quickly. I think you have to use the VBA Macro to quickly achieve it. Just do the following steps:

Step1: open your excel workbook and then click on “Visual Basic” command under DEVELOPER Tab, or just press “ALT+F11” shortcut.

Get the position of the nth using excel vba1
Step2: then the “Visual Basic Editor” window will appear.

Step3: click “Insert” ->”Module” to create a new module.

export each sheet to csv2

el v

Step4: paste the below VBA code  into the code window. Then clicking “Save” button.

open multiple hyperlinks2

Sub OpenMultipleLinks()
    On Error Resume Next
    Set myRange = Application.Selection
    Set myRange = Application.InputBox("Range", "OpenMultipleLinks", myRange.Address, Type:=8)
    For Each oneLink In myRange.Hyperlinks
        oneLink.Follow
    Next
End Sub

Step5: back to the current worksheet, then run the above excel macro. Click Run button.

open multiple hyperlinks1

Step6: please select one range that contain hyperlinks you want to open. click ok button.

open multiple hyperlinks3

Step7: you would see that all of hyperlinks have been opened in your default browser.

 

You might also like:

Sidebar