Opening Hyperlink

  • Thread starter Thread starter Nicki
  • Start date Start date
N

Nicki

Can someone please tell me if and how it is possible to use a keyboard
shortcut to open a hyperlink contained in an excel spreadsheet?

Thanks
 
Assumming the hyperlink is in Sheet1!A1, this will follow/open the hyperlink.

Worksheets("Sheet1").Range("A1").Hyperlinks(1).Follow

You can put that in macro and assign a shortcut key to the macro..
 
you could write a macro something like this

Sub Macro1()
' Keyboard Shortcut: Ctrl+h

Range("C2").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub
 
you could write a macro something like this

Sub Macro1()
' Keyboard Shortcut: Ctrl+h

Range("C2").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub






- Show quoted text -
Click to expand...

I am working with Nicki and have the same question as her. I typed in
what jhyatt told me but it is not working. How do I finalize the
request? Pressing enter does not work.
 
When I hit run it states Subscript out of range. My Data I want to
open is in Column B going from 3 to 2535. What can I do to make this
work?
 
Back
Top