View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sean Sean is offline
external usenet poster
 
Posts: 454
Default 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