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.
Step2: then the “Visual Basic Editor” window will appear.
Step3: click “Insert” ->”Module” to create a new module.
Step4: paste the below VBA code into the code window. Then clicking “Save” button.
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.
Step6: please select one range that contain hyperlinks you want to open. click ok button.
Step7: you would see that all of hyperlinks have been opened in your default browser.