3 Easy Ways to Batch Open Multiple Hyperlinks in Your Excel

If you’d like to batch open multiple hyperlinks in Excel, you can refer to this article. Here we’ll introduce you 3 handy methods. Each of them has its pros and cons. You can choose any as per your needs.

In some cases, when viewing an Excel file that consists of lots of hyperlinks, you may wish to batch open multiple hyperlinks. If there are only three or so links to be opened, you can just use the Method 1 below. Yet, if you want to batch open all links in your wanted ranges, you can use Method 2 instead. Of course, sometimes, you may wish to batch open all links scattered around the entire workbook. Then, you can use the last way.

Method 1: Manually Open Hyperlinks One by One

To open a hyperlink in a cell manually, you can directly click on the cell. Hence, if there are not too many hyperlinks to be opened, you can click on the cells to open the hyperlinks one by one.Click Cell to Open a Hyperlink

Method 2: Batch Open Hyperlinks in Selected Ranges

Yet, at times, you wish to batch open all the hyperlinks in the selected ranges. In this case, you can actually make use of the following VBA code.

  1. First off, trigger VBA editor in the current Excel file according to “How to Run VBA Code in Your Excel“.
  2. Then, put the following code into a module or project.
Sub BatchOpenHyperLinks_SelectedRanges()
    Dim objSelectedRange As Excel.Range
    Dim objHyperlink As Excel.Hyperlink

    'Get selected ranges
    Set objSelectedRange = Excel.Application.Selection
    For Each objHyperlink In objSelectedRange.Hyperlinks
End Sub

VBA Code - Batch Open Hyperlinks in Selected Ranges

  1. After that, add this macro to Quick Access Toolbar or ribbon.
  2. Finally, you can select the desired ranges and click the macro button.Select Ranges and Run Macro
  3. At once, all the hyperlinks in the selected ranges will be opened in the default internet browser.Opened Selected Hyperlinks

Method 3: Batch Open All Hyperlinks in a Workbook

Sometimes, you may want to open all the hyperlinks in a workbook, no matter in which worksheet. In this situation, you can use the VBA code instead.

  1. At first, put the following code into a module or project in VBA editor.
Sub BatchOpenHyperLinks_Workbook()
    Dim objWorksheet As Excel.Worksheet
    Dim objSelectedRange As Excel.Range
    Dim objHyperlink As Excel.Hyperlink

    'Process each worksheet
    For Each objWorksheet In ThisWorkbook.Sheets
        For Each objHyperlink In objWorksheet.Hyperlinks
End Sub

VBA Code - Batch Open All Hyperlinks in a Workbook

  1. Then, press “F5” to run this macro right now.
  2. Immediately, all the hyperlinks in each worksheet will be opened.All Hyperlinks in the Workbook Are Opened

Repair Excel Issues

Like Word documents, Excel workbooks are very vulnerable. That is to say, Excel files can be corrupt for multiple factors, including virus infection, human errors and Excel crashes and so on. Hence, you should prepare a powerful Excel fix tool, such as DataNumen Excel Repair, which can recover Excel data without breaking a sweat.

Author Introduction:

Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including mdf recovery and outlook repair software products. For more information visit www.datanumen.com

3 responses to “3 Easy Ways to Batch Open Multiple Hyperlinks in Your Excel”

  1. whoah this weblog is fantastic i like reading your articles. Keep up the good work! You understand, a lot of people are hunting around for this info, you could help them greatly.

  2. 12 pickup lines for you to make your crush

    Despite what weather (perhaps) insists on, We at the Clog are incredibly excited that it’s now officially fall. And though this implies we can bring out our cozy sweaters and drink pumpkin spice lattes all day, [url=htttps://www.linkedin.com/in/charmingdate]charmingdate.com[/url] It also means that midterms are on the horizon, If not at this time here.

    Exams come with more pressure than normal, panic and anxiety, And willpower on your mind is trying to woo that certain someone you’ve been eyeing since the first day of class. But what you require! We at the Clog have handily gave you some fall themed pickup lines for your romantic pleasure.

    If you just aren’t sure the person you like has reciprocating feelings for you, have right now something a little tamer. And if they don follow through well, you might be both laugh it off. wedding and reception classics that fit perfectly with this season:

    Is your company name Autumn? Cause my spouse and i I’m falling for you.

    You’re so thrilling, I can barely be leaf my eyes.

    Youroutfit crisp as an autumn leaf.

    you might be like those were too reserved, Another easy tactic is to bring up the irresistible food and drinks associated with this time of year:

    Wanna go on a cappuccino date? Cause I like your story a latte.

    I can present you with a better PSL than Starbucks pretty special lovin only thing sweeter than cinnamon is you.

    We wish you great in your endeavors to woo whomever it is that you feel needs wooing, And hope that it makes you seem all the preferable during this gloomy midterm season. And if you find yourself to be the unfortunate receiver of any of these lines, you reply with “Leaf me by ourselves” being assert your own pun making dominance.

Leave a Reply

Your email address will not be published. Required fields are marked *