hi everyone.

I have a file with approx 30 sheets in it.
I'm trying to develop a dropdown list that users can select a sheet from and automatically click on the dropdown list to go there. (either with VBA or hyperlinks). The sheet1, sheet2, sheet3..sheet30 are all contained in the same book1.xls file.

Does anybody have a working model they can share?

Thanks
Conor