I want to the other sheet to look like an hyperlinks in the first sheet !
![]() |
I want to the other sheet to look like an hyperlinks in the first sheet !
You want a list of the other sheets to be hyperlinked, so when you click on them it takes you to that sheet?
CREATE A HYPERLINKED LIST OF SHEETS IN A WORKBOOK ON A FRONT SHEET
This macro creates a "table of contents" on a sheet at the beginning of the workbook. Each sheet listed is also an active Hyperlink so click the name will take you directly to the sheet. Put a link on all your other sheets back to this front sheet and you have an extremely fast navigation system for large workbooks. There's a sample file for you to see this operate.
Once the hyperlinks are created for you, if there are a LOT of links you could reorganize them on that front sheet in any visual way you wish to make them easy to see all at once.
All times are GMT -7. The time now is 10:28 PM. |