Excel Droopdown list

[r70]

If i have a 10 sheets with different names and i have a list of these names how can i create a button to display the worksheet containing the name that i choose from the list

[vandan_tanna]

Rather than a button for each, may be you can hyperlink them.

See discussion here

[r70]

Well Thank you vandan But Im trying to Make one button to all names ...if i choose a name from the list and then clicking the button it will go to the named sheet ...not for each name a button.
r70

[vandan_tanna]

ooops, sorry Arlette...I was typing my post while you posted yours.

[r70]

Thanks Vandan Well done

[vandan_tanna]

Assuming you have a drop down in A1 with your list of Sheet names, then assign your button the following macro:

Sub ActivateSheet()

Dim wSht As Worksheet
Set wSht = Worksheets(Range("A1").Value)

wSht.Select

End Sub