Drop down list linked to Worksheets

[shakeregg]

Hey all,

If someone could help me with this I would really appreciate it.

I have a workbook (named Database) which contains 4 worksheets named Main, Leeds, Bradford, York. Ideally I would like to create a drop down list in Main which lists the other worksheets which when selected will automatically take me to that worksheet.

i.e.

Select Cluster
- - - - - - - - -
Leeds
Bradford
York


Would it also be possible to hide the Leeds,Bradford& York worksheets so thy don't appear as tabs?

Cheeeeeeeeers in advance

 

[Fluff]

How about
Select B6 > Data validation > set Allow to "List" > in source enter Leeds, Bradford, York > Ok
Then in the "Main" sheet code modue paste

Private Sub Worksheet_Activate()
   Dim Sht As Worksheet
   For Each Sht In Sheets(Array("Leeds", "Bradford", "York"))
      Sht.Visible = 0
   Next Sht
   Me.Range("B6").Value = ""
End Sub

Private Sub Worksheet_Change(ByVal Target As Range)
   If Target.CountLarge > 1 Then Exit Sub
   If Target.Address(0, 0) <> "B6" Or Target = "" Then Exit Sub
   With Sheets(Target.Value)
      .Visible = -1
      .Activate
   End With
End Sub

 

[jeffreybrown]

Rule #13 :
We prefer that members do not cross-post questions to other forums, but when this does occur members should do the following:
- Post the details of your question on our forum. Do NOT simply post a link/re-direct to the question in another forum with no details posted here.
- Make it clear that you have cross-posted and provide links to the cross-posts.
Cross-posted questions that do not comply may be deleted or locked. For a discussion on the issues with cross-posting, see this link: Excelguru Help Site - A message to forum cross posters

 

[My Aswer Is This]

I will move on and not try helping with this question since I now see this question has been posted in another forum.