hi
as an alternative....
right click your sheet navigator in the lower left of the screen.
you will get a popup listing the first 15 sheets. there will be another
entry...
"more sheets". cick more sheets and yo will get a pop up text box with
scroll bars
click one to go to it.

Regards
FSt1

"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