I'm familiar with the adding of an "Index" worksheet as the 1st on the left of many worksheets in a workbook and was able to find the following online: (added as right-click -> View Code)
Private Sub Worksheet_Activate()
Dim wSheet As Worksheet
Dim M As Long
M = 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
M = M + 1
With wSheet
.Range("H1").Name = "Start" & wSheet.Index
.Hyperlinks.Add Anchor:=.Range("H1"), Address:="", SubAddress:="Index", TextToDisplay:="Back to Index"
End With
Me.Hyperlinks.Add Anchor:=Me.Cells(M, 1), Address:="", SubAddress:="Start" & wSheet.Index, TextToDisplay:=wSheet.Name
End If
Next wSheet
End Sub
I could use a suggestion on how to best use similar functionality but I'd like to place the newly-added INDEX worksheet as the 5th or 6th worksheet in my file
In other words, I'd like to only include all worksheets RIGHT of the INDEX, but exclude the 1st several tabs from being part of the refreshed Index results.
Any thoughts or assistance is very much appreciated.
Dave
Bookmarks