[rentonhighlands]

What is the keystoke to activate a link? When I press enter excel moves down 1 cell. It does not choose and go to the link.
Tried CTRL ALT SHIFT >Enter

 

[RSpecianjr]

Hey rentonhighlands,

Unfortunately we have become quite dependent on a mouse. There isn't a keyboard command to follow a link in a cell. You can however setup a macro to do it.

Use this code:

Sub Follow_the_Link()
ActiveCell.Hyperlinks(1).Follow
End Sub

And set the macro to a shortcut key. Be aware of what key you set it to, I usually use Ctrl+q because it isn't assigned to anything.

Let us know if you need help setting this up.

Thanks,

Robert D. Specian Jr.

 

[Elkar]

Certain keyboards have a "Shortcut-Menu" button. On mine it is located on the bottom-right in between the Ctrl and Alt keys. I've seen it placed on the top row of laptop keyboards too. Hitting this while on a cell with a hyperlink will bring up a short-cut menu (the same as right-clicking) and on that menu will be an option to "Open Hyperlink". You can hit "O" to activate this. So, it will take two keystrokes instead of one, but if you have that key that's an option.