Dropdown menu hyperlink

[Miguel Villalba]

Hello there, how are you?
this macro helps you creating an index in automatically, on the first tab and it depends on the number of tabs that your workbook has, also if you insert a new one, the index changes by itself.
so I need you help with another macro that put the index on a dropdown menu list with hyperlinks or/and a button that says “go” then if you click on it, you will be sent to the destination tab. (see below the macro)


is it difficult to build? or you can give a clue… I was google it but I am still failing.
thank you!

Private Sub Worksheet_Activate()
 '
 'MACROS BY EXCELZOOM.COM
 '
 Dim wSheet As Worksheet

Dim l As Long

l = 1

With Me

.Columns(1).ClearContents

.Cells(1, 1) = "INDEX"

.Cells(1, 1).Name = "Index"

End With

For Each wSheet In Worksheets

If wSheet.Name <> Me.Name Then

l = l + 1

With wSheet

.Range("A1").Name = "Start_" & wSheet.Index
 .Hyperlinks.Add Anchor:=.Range("A1"), Address:="", _
 SubAddress:="Index", TextToDisplay:="Back to Index"

End With

Me.Hyperlinks.Add Anchor:=Me.Cells(l, 1), Address:="", _
 SubAddress:="Start_" & wSheet.Index, TextToDisplay:=wSheet.Name

End If

Next wSheet



 

End Sub