Need macro to find worksheet...
 

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

Need macro to find worksheet...
 

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

Need macro to find worksheet...
 

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 -

Need macro to find worksheet...
 

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

Need macro to find worksheet...
 

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

Need macro to find worksheet...
 

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

Need macro to find worksheet...
 

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

Need macro to find worksheet...
 

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

Need macro to find worksheet...
 

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