I have found a simple solution to this by using :

CommandBars("Workbook tabs").ShowPopup.

However.... This lists the tabs in the order they appear in the file. There
is a valid reason for the order but I would like the user to be able to pick
from a list alphabetically.

tia

"Gazza" wrote in message
...
I have a workbook that has 100 sheets. I would like to be able to allow the
user to select the sheet they want to go to from a list, upon selecting the
sheet they would be taken to that sheet staight away.

What is the best way of achieving this (Excel 2000)

Thanks

Di.