Locate/goto a specific worksheet quickly

J

johanc

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

starguy

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.
 
B

Bob Phillips

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)
 
S

SandyZapp

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
 
B

Bob Phillips

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)
 
Top