Need macro to find worksheet...

E

E. Miller

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
 
F

FSt1

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
 
J

JP

You probably want something like this? (Sorry, original post not
available)

Sub GoToSheet()
'
' builds a list of sheet names and asks you to pick which one you want
' type in the number to jump to that sheet
'
'
Dim MyShts As Long, MyList As String
MyShts = ActiveWorkbook.Sheets.count

For i = 1 To MyShts
MyList = MyList & i & " - " & ActiveWorkbook.Sheets(i).Name & " "
& vbCr
Next i

Dim MySht As Single
MySht = InputBox("Select sheet by entering its number." & vbCr & vbCr
& MyList)

Sheets(MySht).Select

End Sub

(from: http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm)

HTH,
JP
 
E

E. Miller

Yes, I am aware of the right-click tool, but the sheets I normally need to
access are on the far right of list of tabs making this option
inconvenient.....

Thanks though for the suggestion.
 
E

E. Miller

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

Dave Peterson

What about the second suggestion?

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

E. Miller

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
 
G

Gord Dibben

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

http://tinyurl.com/yoa3dw



Gord Dibben MS Excel MVP

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
Click to expand...
 
Top