I also like Bob Phillips' browsesheets macro as an alternative to a Toolbar.

http://tinyurl.com/yoa3dw



Gord Dibben MS Excel MVP

On Fri, 8 Feb 2008 10:43:03 -0800, E. Miller
wrote:

My appologies Dave, your second suggestion was exactly what I was looking
for. Guess I need to slow down a little when reading. I appreciate the help.

Thanks

Eric

"Dave Peterson" wrote:

What about the second suggestion?

E. Miller wrote:

The "VCR" buttons are not very convenient when dealing with 50+ worksheets.
That's a lot of clicking to move through dozens of sheets.

"Dave Peterson" wrote:

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


--

Dave Peterson