You can right click on the VCR/DVD like controls (to the left of the worksheet
tabs) and choose a worksheet from that list.

or you may want to try this from Debra Dalgleish's site:
http://contextures.com/xlToolbar01.html

E. Miller wrote:

I have an Excel workbook that contains well in excess of 50 worksheets. I
recently had a macro that I found on a website mentioned on this board that
would produce a drop-down list of all the worksheets where I could click on
the sheet needed and that sheet would then pop up as the active sheet.
Unfortunatly, my work computer hard drive had to be replaced and I lost the
macro. Anybody know where I might find this macro or another macro or add-in
that would do the same thing? I would greatly appreciate any help.

thanks

Eric

--

Dave Peterson