How to open hyperlinks in excel without mouse-click; is there any shortcut key/Keys
Press the menu key and then press 'O' or 'o'.
More about Menu Key: http://en.wikipedia.org/wiki/Menu_key
Create a macro with the following. The cell with the link should only include text of the hyperlink (and not use the Excel function hyperlink with an embedded link). Note that the "... chrome.exe " has a [space] between exe and quote (").
Sub ClickHyperlnk()
'
' ClickHyperlnk Macro
'
' Keyboard Shortcut: Ctrl+d
'
With Selection.Interior
URL = ActiveCell.Value
Shell "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe " & URL, vbNormalNoFocus
End With
End Sub
This is an old post but maybe it could help someone searching for this shortcut. To open a link without going through "Edit Links" follow these couple of steps:
- click on a cell that is linked to another file
- then press Ctrl + [
This will open the linked file. Hope this helps.