Navigating between worksheets using a drop down menu

N

ncdogteam

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
 
D

Die_Another_Day

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
 
R

Ragdyer

XL has a built-in sheet list that is accessible by simply right clicking in
the small directional arrows to the left of the sheet tabs.
This gives you a list of the first 15 sheets, with an option to expand the
list to an infinitely scrolling list of *all* the sheets.

Click on a name, and the sheet is immediately selected.
 
Top