MD1907
09-26-2019, 02:48 PM
I want to use cell names or names of named ranges as bookmarks. When I save as pdf I need these bookmarks to carry over to the pdf document.
Is there a macro that can do this? Excel 365 with Adobe add-in. Adobe creates bookmark from Worksheet names ok but need it (or Excel) to create bookmarks from e.g. cell names and if possible hierarchical / tree menu as it does easily when creating pdfs from e.g. Word documents. Single Excel sheet I convert is saved as 60 pages, need these bookmarked for presentation as pdf.
Is there a macro that can do this? Excel 365 with Adobe add-in. Adobe creates bookmark from Worksheet names ok but need it (or Excel) to create bookmarks from e.g. cell names and if possible hierarchical / tree menu as it does easily when creating pdfs from e.g. Word documents. Single Excel sheet I convert is saved as 60 pages, need these bookmarked for presentation as pdf.