Linking Pages in a workbook.
How can I create links between pages in a workbook? For example I have a workbook with over 100 sheets. On the first sheet I want to create a summary page with links in all the cells to each page so you can just click and it takes you to sheet 100 or 75 or whatever. Then vice versa to get back to summary page from sheet 100 or 75.
Rachelle.
| Attachment | Size |
|---|---|
| Linking Pages in a workbook..xls | 65.5 KB |
VBA solution for automatic link between pages in a workbook
Although hyperlinks could be a way to link between sheets in a workbook, I think that it costs a lot of effort and time to establish all required links (as twice as many sheets in the workbook).
I wrote a piece of code in a workbook containing a summary sheet that lists automatically all other sheets of the workbook. A double click on the cell containing the sheet name is enough to activate corresponding sheet. To go back to the summary sheet, all you need is to double click on a blank cell.
To populate the workbook, you may drag and drop your own sheets in that magic workbook.
You may delete any unwanted sheet.
I do not find any way to upload this workbook.
Please click on this link to download the workbook.
Your comments are welcome.
Imed.
That didn't work
I tried that 27 lessons and there is no 'HOME' button on my ribbon whatever that means. I am running Excel 2003 if that makes a difference. Ha ha help.
hyperlink 2003
I don't have 2003, but if I remember correctly, it's under: Insert => hyperlink
linking pages in a workbook
Check this out:
excelexperts.com/Teach-Yourself-Excel-Lesson-27-Create-Hyperlinks