General discussion

Locked

Keyboard shortcut to follow formula-generated hyperlinks in excel?

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(<test>;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,

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