Hi
I tried looking for an answer in the forum but i couldn’t find it.
My libreoffice sheet has a collumn with hyperlinks, something like this
A
1 www.a.com
2 www.b.com
3 www.c.com
4 www.d.com
5 www.e.com
…
I need to find a way of opening all hyperlinks without clicking them all, the purpose is to select a range, for example A1:A10, run a script and make the selected cells to open in browser tabs automatically. I have a piece of code that works on excel but not on libreoffice:
Sub Open_HyperLinks()
Dim hl As Hyperlink
On Error Resume Next
For Each hl In Selection.Hyperlinks
hl.Follow
Next hl
End Sub
Is there any way of making this work on calc? Thank you