Maybe you can use or adapt this (which uses a toolbar):

http://www.contextures.com/xlToolbar01.html
from Debra Dalgleish's site.

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

--

Dave Peterson