Sheets(nameOfTableOfContentsWorksheet).Cells(i + 5, 2).SelectĪctiveSheet.Hyperlinks. Sheets(nameOfTableOfContentsWorksheet).Cells(i + 5, 2) = tempWorksheetName TempLink = "'" & tempWorksheetName & "'!R1C1" '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 With the recent upgrade, I no longer can save the PDFs separately with one click of a button. I would go to file - save as pdf - workbook and it would produce separate PDFs saved as the tab name. I have many workbooks that have unique tabs that I would save as separate PDFs. 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. I recently upgraded to excel for mac version 16.20 from version 14.5.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |