View Full Version : select a sheet from list
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?
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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.