General discussion


Keyboard shortcut to follow formula-generated hyperlinks in excel?

By trasheurfou ·
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()
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 :


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!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Related Discussions

Related Forums