In the lower left-hand corner of the worksheet are the directional buttons...
|< , < , , |
Right-click on these buttons and a list of all worksheets in the active
workbook will appear. Highlight the last one and hit enter.
HTH,
Gary Brown

" wrote:

hi,
what i would do is create start tab. on that sheet i would
create a button for each department and put their
department number as the buttons caption.
then for code behind the button i would put something like
Private sub cmd100_click()
Sheets("100").select
Range("A1").select
end sub
and do that for each button(department)
that way whoever opened the file could click their
department button and be taken to their sheet instantly.
repost to this thread if you have questions.
good luck

-----Original Message-----
I have a file that contains many workseet tabs.

The tables are numbered, like, 100, 200, 300, 400, 500,
etc and represent
names of departments

An individual from a given department will open the
workbook, and select
their respective tab.

If thier department number is at the end of the range, it
is difficult for
them to scroll across the bottom of the workbook to find
thier sheet tab.

Is there a better way to organize or find worksheet tabs?

Can worksheet tabs be listed down the left margin instead
of across the
bottom?

Is there a way to create a "table of contents" or
something similar that
will access the individual tabs?

I did see Views, create custom view, and this looks like
it work work,
however since another program creates the excel workbook
and all the tabs
each month, I would have to do a l;ot of manula editing
to create a custom
view. Is there a better way?


.