Hi Charlie,
The wb holds plus 60 ws hence I need to find an easier meethod that will
work for some 600 users. I have a hyperlinked index but it is getting
unwieldly.

Thanks,
Mickey



"Charlie" wrote in message
...
How 'bout right-clicking on the tab-scroll-arrows down there in the
lower-left corner of the workbook?

"Mickey" wrote:

Hi,
Please could someone advise how best to complete the following -

I have a workbook with quite a lot of worksheets. To simplify navigation
I
would like to use three comboxes in the following way -

Combobox 1 populated with a top level list of items.
Combobox 2 populated with a sub list based on the top level item selected
in
combobox 1
Combobox 3 then populated with a sub list of items following selection in
box 2. The items in combobox 3 to act as a hyperlink to the selected
worksheet.

For example,
Combobox 1 holds the values Apples & Pairs, User selects Apples and
Combobox
2 then populates with Baking, Cooking or Salad. User selects Cooking and
selection hyperlinks to the worksheet named 'Cooking'.

Thanks,
Mickey
ps. An alternative may be to just have a long list in one listbox, can I
have it so that the chosen item then hyperlinks to the selected
worksheet?