I have written my own code to do this and I will email it to you if you
would like, however, if you right click the arrows that let you
navigate the next/previous sheet it pops up a menu that lets you select
the sheet you wish to go to.

HTH

Die_Another_Day
ncdogteam wrote:
I have been searching the forums but I don't seem to hit the correct
search criterias, please help


I need to create a drop down menu on one of my worksheets. The list
should contain all the woksheet/tabs in the workbook and allow me to
navigate to any sheet. When a new sheet is added it should also be
added to the drop down menu.


--
ncdogteam
------------------------------------------------------------------------
ncdogteam's Profile: http://www.excelforum.com/member.php...o&userid=36342
View this thread: http://www.excelforum.com/showthread...hreadid=561281