Supposing I have a lot of hyperlinks in a worksheet, normally, I can open them by clicking them one by one, but click multiple times will be annoying, so, I want if there is a quick way to open all of the selected hyperlinks at the same time. From the below article, I can solve this task with an easy way. Open multiple hyperlinks at once with VBA code Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier... Read More... Free Download... Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Read More... Free Download... Open multiple hyperlinks at once with VBA codeAmazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!Save 50% of your time, and reduce thousands of mouse clicks for you every day!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
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. Related articles: How to remove / delete all or multiple hyperlinks in Excel? How to remove hyperlinks without removing formatting? How to change multiple hyperlink paths at once in Excel? The Best Office Productivity ToolsKutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Read More... Free Download... Purchase... Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
Read More... Free Download... Purchase...
Oldest First Sort comments by Oldest First Newest First Comments (19) No ratings yet. Be the first to rate! Priya about 6 years ago #16260 This comment was minimized by the moderator on the site Hi This code is really helpful but it is asking to select the range, could you tell me how to midify this code for below situation ... hyperlinks are already placed in cell A1:C1 to A300:C300 , in D1 there should be link, on clicking D1, the hyperlinks from A1:C1 should open at once similarly by clicking D2 , hyperlinks from A2:C2 should open at once and so on. Could you please help Reply 0 0 Adrian Tyson about 6 years ago #16950 This comment was minimized by the moderator on the site Hi, Thank you so much!! Its very useful for my process, but its not working on the following hyperlink =HYPERLINK("mailto:" & A3 & "?subject="& B3, "adrian") It again gets back to the module page. Can some one help me on this please!! BR, Adrian Reply 0 0 AC Adrian Tyson about 3 years ago #16951 This comment was minimized by the moderator on the site What answer have you found two years since? Reply 0 0 jagdish gaba about 5 years ago #18071 This comment was minimized by the moderator on the site hi this code is very helpful. can u pls explain, how to print multiple hyperlinks. pls provide code Reply 0 0 wojtek_bookworm about 5 years ago #19279 This comment was minimized by the moderator on the site Does not work. Links don't open. Reply 0 0 Jeremie wojtek_bookworm about 5 years ago #19280 This comment was minimized by the moderator on the site [quote]Does not work. Links don't open.By wojtek_bookworm[/quote] Make sure the value is a hyperlink Reply 0 0 Ben about 4 years ago #24058 This comment was minimized by the moderator on the site Does not work for me: after selecting a range, nothing happens. Values are valid URLs. Reply 0 0 Vaibhav Jain about 4 years ago #24059 This comment was minimized by the moderator on the site Please let me know hpw does it work in Mac Reply Report 0 0 John about 3 years ago #28339 This comment was minimized by the moderator on the site Freezes excel - links never open Reply 0 0 maov about 3 years ago #29035 This comment was minimized by the moderator on the site Thanks! Reply 0 0 James about 3 years ago #29907 This comment was minimized by the moderator on the site When I use this on a column of hyperlinks generated by the =HYPERLINK() formula, it doesn't seem to work. When I copy/paste the values into a new column and run it there, it doesn't work. When I go to each individual cell, go to the end of text, and hit enter (causing it to become a hyperlink) it DOES work. Reply 0 0 Johan Nersnæs James about 3 years ago #29908 This comment was minimized by the moderator on the site Found a solution? Reply 0 0 SimpleDude Johan Nersnæs about 3 years ago #29909 This comment was minimized by the moderator on the site @James @Johan - Select the text you wish to convert into hyperlink, then use this code to convert the text into hyperlink directly. Then run the code above, works like a charm. Reply 0 0 HowDoIComputer SimpleDude about 2 years ago #29910 This comment was minimized by the moderator on the site Hello! What I did was to copy/paste the values from the =HYPERLINK code into a different column, and then I used @SimpleDude's code to convert the pasted text into the hyperlinks that worked with the original hyperlink-opening code. Thank you for the help! |