Question

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,
--
Sam

This conversation is currently closed to new comments.

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

All Answers

Collapse -

Flip it around

by Bizzo In reply to Keyboard shortcut to foll ...

An example that seems to work:
=HYPERLINK(IF(<test>,"http://www.microsoft.com"," "))

Although this doesn't allow you to give different "friendly names" to the link/nolink.

Collapse -

thanks

by trasheurfou In reply to Flip it around

Thanks a lot Bizzo, it works indeed and it's a lot better than nothing. =)

I'll do it this way for now, but I'm still interested in a way that would save me the work of manually modifying all my formulas.

So if anyone's got an idea I'm taking it !

Collapse -

up

by trasheurfou In reply to thanks
Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums