Software

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

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.

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

up ^_^

Related Discussions

Related Forums