Locate/goto a specific worksheet quickly
 

I use 60 worksheets - how do I quickly move to e.g. sheet 52 without having
to use the arrows?

Locate/goto a specific worksheet quickly
 

right click on the arrows at the left most side of your sheet tabs,
click more sheets and select your required sheet you want to move to.

johanc Wrote:
I use 60 worksheets - how do I quickly move to e.g. sheet 52 without
having
to use the arrows?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=558061

Locate/goto a specific worksheet quickly
 

I added a dropdown into a toolbar and loaded it like so


Dim sh As Object
With Application.CommandBars("Custom Toolbar").Controls("Goto Sheet")
.Clear
For Each sh In Wb.Sheets
.AddItem sh.Name
Next sh
.ListIndex = 1
End With

then I can select from the dropdown.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"johanc" wrote in message
...
I use 60 worksheets - how do I quickly move to e.g. sheet 52 without
having
to use the arrows?

Locate/goto a specific worksheet quickly
 

What a great idea! Would I just add the code below as a macro, or is there a
place through tool bars I should put it?
Thanks! Sandy

"Bob Phillips" wrote:

I added a dropdown into a toolbar and loaded it like so


Dim sh As Object
With Application.CommandBars("Custom Toolbar").Controls("Goto Sheet")
.Clear
For Each sh In Wb.Sheets
.AddItem sh.Name
Next sh
.ListIndex = 1
End With

then I can select from the dropdown.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"johanc" wrote in message
...
I use 60 worksheets - how do I quickly move to e.g. sheet 52 without
having
to use the arrows?

Locate/goto a specific worksheet quickly
 

Hi Sandy,

First I add the dropdown to a toolbar, such as Standard, then I add
application events to reload it every time a workbook is activated (that way
it functions for all workbooks). The toolbar and event code is added from
Personal .xls. I can knock you up an example if you wish.


--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"SandyZapp" wrote in message
...
What a great idea! Would I just add the code below as a macro, or is
there a
place through tool bars I should put it?
Thanks! Sandy

"Bob Phillips" wrote:

I added a dropdown into a toolbar and loaded it like so


Dim sh As Object
With Application.CommandBars("Custom Toolbar").Controls("Goto
Sheet")
.Clear
For Each sh In Wb.Sheets
.AddItem sh.Name
Next sh
.ListIndex = 1
End With

then I can select from the dropdown.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"johanc" wrote in message
...
I use 60 worksheets - how do I quickly move to e.g. sheet 52 without
having
to use the arrows?