Pop up Box that displays files sheets Q
 

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

Pop up Box that displays files sheets Q
 

On Dec 2, 1:09 am, Sean wrote:
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

this is the same as right clicking on the nav tabs(Arrows beside the
sheet tabs), that shows only visible sheet tabs, I would say no, of
course there are other codes that can do what you ask, but maybe the
real question is, why do you need to have a specific sheet visible, I
am assuming it is for vba reasons,with a select method