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

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

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...ans_macros.htm)

HTH,
JP

On Feb 8, 11:17*am, FSt1 wrote:
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- Hide quoted text -

- Show quoted text -

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.

"FSt1" wrote:

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

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

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

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

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

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