Opening Multiple URLs or Hyperlinks In Zoho Sheet

Opening Multiple URLs or Hyperlinks In Zoho Sheet

Hi there,

I have a long list of urls in a spreadsheet:

http://facebook.com
http://perfectclicks.com
http://twitter.com

Problem:

When I click on each one, it opens in a new tab and automatically takes me to that tab. This makes it very slow to open a long list of urls.

Potential Fix #1:

Can I stay on the current tab when clicking a hyperlink? There should be an option to uncheck "When I open a link in a new tab, switch to it immediately" just like Firefox has. Or, a short cut for this would be great.

Potential Fix #2:

Or, can I open multiple urls at one time? I have tried a few macros for excel, but can't get it to work with Zoho sheets. Maybe you can give me a modified version of this:

  1. Sub OpenHyperLinks()
  2. 'Update 20141124
  3.     Dim xHyperlink As Hyperlink
  4.     Dim WorkRng As Range
  5.     On Error Resume Next
  6.     xTitleId = "KutoolsforExcel"
  7.     Set WorkRng = Application.Selection
  8.     Set WorkRng = Application.InputBox("Range", xTitleId, WorkRng.Address, Type:=8)
  9.     For Each xHyperlink In WorkRng.Hyperlinks
  10.         xHyperlink.Follow
  11.     NextEnd Sub

Please let me know if you can make either solution work.

Thanks,
Chad