Data Validation
Is there a way when using a data validation list, to hyperlink the list
options to pages in the workbook? So for example, if you had a lot of worksheets in one workbook, is there a way to choose a worksheet from the list and have it go to the corresponding worksheet? Thank you. |
Data Validation
Say cell A1 has the data validation pull-down. Insert the following
worksheet code event: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub Sheets(Target.Value).Activate End Sub After selecting a sheet name in cell A1, that sheet will automatically be selected. -- Gary''s Student - gsnu200771 "Destiney" wrote: Is there a way when using a data validation list, to hyperlink the list options to pages in the workbook? So for example, if you had a lot of worksheets in one workbook, is there a way to choose a worksheet from the list and have it go to the corresponding worksheet? Thank you. |
Data Validation
Yes, but there are other ways to select a sheet to go to.
Right-click on the navigation arrows at bottom left to get a list of 15 sheets and "more sheets". Rather than an dropdown list sheet with hyperlinks, try a sheet navigation toolbar or similar. Sheet navigation bar from by Dave Peterson at Debra Dalgleish's site. http://www.contextures.on.ca/xlToolbar01.html Or Bob Phillips' Browsesheets macro. See this google search result. http://tinyurl.com/yoa3dw Gord Dibben MS Excel MVP On Mon, 3 Mar 2008 17:22:06 -0800, Destiney wrote: Is there a way when using a data validation list, to hyperlink the list options to pages in the workbook? So for example, if you had a lot of worksheets in one workbook, is there a way to choose a worksheet from the list and have it go to the corresponding worksheet? Thank you. |
All times are GMT +1. The time now is 02:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com