Drop Down Menu Options?

[ibo4lyf]

I've applied this to a project of mine and it works great.
http://www.excelforum.com/showthread.php?t=474588

Although with my project I have a workbook with over 250 sheets :-)

Is their a way to limit the amount of sheets displayed in the drop down box?

also if the above is possible...

Is their a way to have different set of sheets displayed for each worksheet?

For example, on "sheet 1", the drop down only displays sheets 2-5. Upon the users arrival to sheet 4, the drop down menu displays sheets 30-50.

Thanks for the help in advance.

[Leith Ross]

Hello ,

Welcome to the Forum!

As a new member of the Forum please read the rules. You can click on the link below...
Forum Rules

Sincerely,
Leith Ross

[ibo4lyf]

Big thanks to groups user huntermcg for this find.

I have entered this into my "ThisWorkbook" -

Please Login or Register  to view this content.

and then I entered this into a module -

Please Login or Register  to view this content.

This created a neat little drop down menu for sheet navigation.
(thanks to Bob Phillips for the code at
http://www.excelforum.com/newreply.p...te=1&p=1358771)

QUESTION -

I've applied this to a project of mine and it works great.

Although with my project I have a workbook with over 250 sheets :-)

Is their a way to limit the amount of sheets displayed in the drop
down box?

also if the above is possible...

Is their a way to have different set of sheets displayed for each
worksheet?

For example, on "sheet 1", the drop down only displays sheets 2-5.
Upon the users arrival to sheet 4, the drop down menu displays sheets
30-50.

Thanks for the help in advance.

[Leith Ross]

Hello ibo4lyf,

I wrapped your code this time because you are a new member. In the future you should do this to make your code easier to read and edit for everyone else in the form.

How to wrap your Code
On the Message window Toolbar you will see the # icon. This will automatically wrap the text you selected with the proper HTML tags to create a Code Window in your post. You can do this manually by placing the tag [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] at the end.

Thanks,
Leith Ross