1 Attachment(s)
Automatically Create Table Of Contents For Workbook
https://www.youtube.com/watch?v=SbN3iIiiPyY
If the workbook contains many sheets , a table of contents can be created to navigate easier between the sheets.
This process can be done with macro codes.
This macro will create a new sheet at the start of the workbook named "Workbook_Index" when workbook opened. If this sheet already exists it will remove it and will rebuild. The macro will then list the names of all the sheets in the workbook and insert a hyperlink for each one.Also,can be returned to table of contents when the "Esc" key is pressed while on any sheet.
Re: Automatically Create Table Of Contents For Workbook
Sounds suspiciously like an assignment.
What code have you got and where does it not work?
Re: Automatically Create Table Of Contents For Workbook
Codes are in template that I added .
Re: Automatically Create Table Of Contents For Workbook
is this a question? or just an example of how to automatically create a TOC
