Excel file with over 50 worksheets - need scroll menu on the first worksheet with all other worksheets

[JBijl]

Hi,

First of all - thank you for being willing to look at my issue.

I have a workbook with over 50 worksheets (tabs). Now scrolling between these worksheets to find the correct one is tedious and unpractical. Is there a way to make some kind of scroll menu on the first worksheet that shows all the different other worksheets so I can simply scroll through those?

Most ideally this scroll menu would automatically include new worksheets that will be made after creating this scroll menu.

Thanks in advance for helping and please let me know if I am being unclear.

Jack

 

[Armando Montes]

Right click any of the arrows bottom left and a menu shows.

 

[JBijl]

Right click any of the arrows bottom left and a menu shows.

Thanks Armando,

That is basically what I was looking for but then would love to have something like that as a scroll menu on the first worksheet. The file needs to go to clients and it is not very practical to explain that (very practical) tip you gave.

It needs to be super easy and clearly visible....

Thanks again for the handy tip - I will certainly be using it personally...

 

[Armando Montes]

Here is one option:
http://www.thesimplemachine.com/vba-list-and-hyperlink-each-worksheet-in-excel/

 

[Armando Montes]

One more:
How to quickly insert sheet names in cells in Excel?

 

[JBijl]

One more:
How to quickly insert sheet names in cells in Excel?

Thanks again for the help... It really helped me in the right direction. I ended up writing up a new Macro though. For your info, see below:

Dim WSM As Worksheet
Dim WS As Worksheet
Set WSM = Worksheets("Base Page")

Ctr = 0

For Each WS In ActiveWorkbook.Worksheets
If Not WS.Name = "Base Page" Then
WSM.Activate
WSM.Cells(1 + Ctr, 6).Select
WSM.Hyperlinks.Add Anchor:=Selection, _
Address:="", _
SubAddress:=WS.Name & "!A1", _
TextToDisplay:=WS.Name
Ctr = Ctr + 1
End If
Next WS