Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlink
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Dim Lk As Hyperlink How can I have this open up the range in the order it is listed? It opens the hyperlinks in a different order. Like A10, A3, A21, A7. 'If you select A30 If Not Intersect(Target, Range("A30")) Is Nothing Then 'for all hyperlink in this range For Each Lk In Range("A2,A3,A4,A6,A7,A9,A10,A13,A14,A15,A20,A21,A 24,A27,A28,A29").Hyperlinks 'open hperlink in same window Lk.Follow False Next End If End Sub -- Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) | |||
Macro to Copy Hyperlink to another file as a HYPERLINK, not text... | Excel Programming | |||
reading html when hyperlink address not hyperlink text diplayed | Excel Programming |