I picked up the code below from the archives which shows a neat pop-up
box that shows the visible sheets in my file and I can select which
one I want to navigate to. Is it possible to specifically exclude from
this list a named file? I need the file to be visible, so can't hide
it

Sub SelectEmployee()
On Error Resume Next
If ActiveWorkbook.Sheets.Count <= 16 Then
Application.CommandBars("Workbook Tabs").ShowPopup 500, 225
Else
Application.CommandBars("Workbook Tabs").Controls("More
Sheets...").Execute
End If
On Error GoTo 0
End Sub