open hyperlinks in column automatically

asked 2019-06-04 17:15:04 +0200

pdjm1 gravatar image

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 2 3 4 5 ...

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

edit retag flag offensive close merge delete