Hi, looking for some help. I have a workbook with approx 250 sheets. I would like a drop down menu (Valadation) that lists all the sheets in the workbook and after I select one of the sheets from the wok book it will take me to that sheet. Any suggestions? Thanks as always.
Why not just right click the navigation arrows to the bottom left of the workbook and choose your sheet from there?
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
Well that was easy. Thanks so much, never knew that one.
Don't know if this would appeal to you but I find it very handy for workbooks with lots of worksheets.
Ron
Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes.
Posting Permissions
Reply With Quote
