Question

  • Creator
    Topic
  • #2153936

    Keyboard shortcut to follow formula-generated hyperlinks in excel?

    Locked

    by trasheurfou ·

    Hi,
    I have an excel file with many formula-generated hyperlinks. Instead of clicking them, I would prefer opening them with a keyboard shortcut so I made a macro :

    Sub followMyLink()
    ActiveCell.Hyperlinks(1).Follow
    End Sub

    which works for cells in which the hyperlink was built using ctrl+k, but not when the hyperlink is the result of a formula such as :

    =IF(;HYPERLINK(“URL1″;”name1”);nolink)

    Running followMyLink on such a cell fails because it doesn’t have any hyperlinks associated to it.

    I know I could build a macro that would do the “IF” test AND follow the link, but I’d rather the two functions be separate.

    Any help appreciated!
    Regards,

    Sam

All Answers

Viewing 1 reply thread