How to open multiple hyperlinks at once in Excel?
If you have many hyperlinks in a spreadsheet, normally you would have to open them one by one, which can be tedious. Fortunately, there are some simple ways to open all the selected hyperlinks at once. By following the methods described below, you can easily accomplish this task.
Open multiple hyperlinks at once with VBA code
To open your selected hyperlinks of a range at once, the following VBA code can help you, please do as this:
1. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following code in the Module Window.
VBA code: Open multiple hyperlinks at once
Sub OpenHyperLinks()
'Updateby Extendoffice
Dim xHyperlink As Hyperlink
Dim WorkRng As Range
On Error Resume Next
xTitleId = "KutoolsforExcel"
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
3. Then press F5 key to run this code, and a prompt box will pop out to remind you to select a range including hyperlinks that you want to open at once time, see screenshot:
4. And then click OK, all the hyperlinks are opened at the same time without clicking them.
Open multiple hyperlinks at once with Kutools AI Aide
Unlock the power of efficiency with Kutools AI Aide! Say goodbye to the hassle of opening hyperlinks one by one or complex code. With Kutools AI Aide, you can effortlessly open multiple hyperlinks simultaneously with just a click. Streamline your workflow and save valuable time by utilizing this innovative tool. Experience seamless browsing and enhance your productivity with Kutools AI Aide today!
After installing Kutools for Excel, please click Kutools AI > AI Aide to open the Kutools AI Aide pane:
- Select the data list, then type your requirement into the chat box, and click Send button or press Enter key to send the question;
"Open all hyperlinks at once in the selection:" - After analyzing, click Execute button to run. Kutools AI Aide will process your request using AI and open all hyperlinks of the selection directly in Excel.
Related articles:
- Change multiple hyperlink paths at once in Excel
- For some purpose, you may create multiple hyperlinks for your data in the worksheet, and all of the hyperlinks are linked to the same file path or address, but now, you need to replace this hyperlink path with another address at a time. To change the path of the hyperlinks individually may waste a lot of time, is there a quick way to solve this problem?
- Convert multiple email addresses to hyperlinks in Excel
- If you have a list of plain text email addresses in a worksheet, and now, you want to convert theses email addresses to hyperlinks that you can send emails while clicking the addresses. Of course, you can convert them to hyperlinked email addresses, but, this method will be boring if there are multiple addresses needed to be converted. In this article, I will talk about some good tricks to deal with this task.
- Follow hyperlink to hidden sheet in Excel
- For example, I have a workbook which contains multiple worksheets, the first master sheet has hyperlinks to other sheets, and now, I hide all sheets except the first one. In this case, the hyperlinks which link to hidden sheets are not available. But, how could you make these hyperlinks work successfully? When you click one hyperlink, the linked hidden sheet will be opened at once.
- Convert a bunch of text URLs to active hyperlinks in Excel
- If you have a list of URL addresses which are plain text, how could you activate theses text URLs to the clickable hyperlinks as following screenshot shown?
Best Office Productivity Tools
Supercharge Your Excel Skills with Kutools for Excel, and Experience Efficiency Like Never Before. Kutools for Excel Offers Over 300 Advanced Features to Boost Productivity and Save Time. Click Here to Get The Feature You Need The Most...
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
- Enable tabbed editing and reading in Word, Excel, PowerPoint, Publisher, Access, Visio and Project.
- Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!