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