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 3 worksheets which when selected will automatically take me to that worksheet.

i.e.

Select Option
- - - - - - - - -
Leeds
Bradford
York


Would it also be possible to hide the Leeds,Bradford& York worksheets so thy don't appear as tabs? So the only option for the user is to access these 3 worksheets (Leeds, Bradford, York) through the ComboBox?

Cheeeeeeeeers in advance