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?