![]() ![]() ![]() Sheets(nameOfTableOfContentsWorksheet).Cells(i + 5, 2).SelectĪctiveSheet.Hyperlinks. Sheets(nameOfTableOfContentsWorksheet).Cells(i + 5, 2) = tempWorksheetName For this project I am using a sample brief found on the website for Ohios 12th District Court of Appeals. After using this tutorial you can use my next tutorial to learn how to Create a Table of Contents for a legal brief with Microsoft Word. Now that you’ve learnt how to insert a table of contents, why not try your hand at inserting an index in your Word. When you create a table of contents in Word, page numbers are added automatically based on the. TempLink = "'" & tempWorksheetName & "'!R1C1" For this project I am using Microsoft Word 2007, but the steps are the same for 20. This wikiHow teaches you how to customize and update the table of contents in your Word document. 'Create the link from the current worksheet and link it to cell A1 Range("B3") = nameOfTableOfContentsWorksheet NameOfTableOfContentsWorksheet = "TableOfContents"ĪctiveSheet.Name = nameOfTableOfContentsWorksheet The macro is supposed to do the same steps: Walk through all sheets, create a list entry for each sheet and insert a hyperlink to each sheet.ĭim tempWorksheetName, tempLink, nameOfTableOfContentsWorksheet As String ![]() As the first two methods works but is quite troublesome – especially for large workbooks – we’ll take a look at a third method: A VBA macro. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |