-1

I have an Excel tool that generates links to intranet website. Is it possible to open hyperlinks in Internet Explorer in a next tab instead of new window? Only IE is an option as it's the company equipment with little user rights.

Improve this question
2
  • What sort of Link? Is this a button in a UserForm (using VBA to open the link), or a Hyperlink in the Worksheet?
    – Chronocidal
    Commented Jun 5, 2020 at 16:08
  • Its a hyperlink function in an Excel cell. =Hyperlink("https path")
    – Dr3wno
    Commented Jun 5, 2020 at 16:12

2 Answers 2

Reset to default
0

Reference Link:

excel-open-all-links-in-a-new-tab

You need to use Follow keyword

Sub OpenAll()
    Dim H As Hyperlink

    For Each H In ActiveWorkbook.ActiveSheet.UsedRange.Hyperlinks
        H.Follow
    Next
End Sub
Improve this answer
0

Apparently changing internet options in IE did the trick.

Improve this answer
1
  • You could explain more about what options you use and mark your answer as an accepted answer after 48 hrs, when it is available to mark. It can help other community members in future in similar kind of issues. Thanks for your understanding.
    – Yu Zhou
    Commented Jun 8, 2020 at 1:52

Not the answer you're looking for? Browse other questions tagged or ask your own question.