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.

1 total post (Page 1 of 1)  
Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums