PDA

View Full Version : select a sheet from list



wilg
01-05-2011, 09:01 PM
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.

Simon Lloyd
01-05-2011, 09:29 PM
Why not just right click the navigation arrows to the bottom left of the workbook and choose your sheet from there?

wilg
01-05-2011, 10:08 PM
Well that was easy. Thanks so much, never knew that one.

CaptRon
01-12-2011, 11:42 PM
Don't know if this would appeal to you but I find it very handy for workbooks with lots of worksheets.

Ron