Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Hyperlink
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Hyperlink
Assumming the hyperlink is in Sheet1!A1, this will follow/open the hyperlink.
Worksheets("Sheet1").Range("A1").Hyperlinks(1).Fol low You can put that in macro and assign a shortcut key to the macro.. -- Hope that helps. Vergel Adriano "Nicki" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Hyperlink
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 "Nicki" wrote: 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Hyperlink
On Sep 18, 12:38 pm, jhyatt wrote:
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 "Nicki" wrote: 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- Hide quoted text - - Show quoted text - 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening Hyperlink
On Sep 18, 3:34 pm, wrote:
On Sep 18, 12:38 pm, jhyatt wrote: 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 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? "Nicki" wrote: 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- Hide quoted text - - Show quoted text - 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.- Hide quoted text - - Show quoted text - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink 4 Opening More Than 1 File. | Excel Discussion (Misc queries) | |||
warning when opening hyperlink | Excel Discussion (Misc queries) | |||
Hyperlink to jpg only opening in explorer | Excel Discussion (Misc queries) | |||
Hyperlink to rtf only opening in MS Word | Excel Discussion (Misc queries) | |||
Hyperlink not opening | Excel Discussion (Misc queries) |