hyperlinks in PDF

[snb]

Hallo allen,

Ik sla een Excel werkblad op als PDF.
Het werkblad bevat hyperlinks, die verwijzen naar diverse benoemde gebieden in het werkblad zelf.
Hoe kan ik ervoor zorgen dat ook het PDF-bestand dezelfde hyperlinks bevat ?

 

[AHulpje]

Dit zegt ChatGPT:

PDFs love bookmarks. Excel can create them — you just have to nudge it.​

---

Step 1: Make each target a “heading”​

Go to the cell where each named range starts and:

• Select the row (or just the main cell)
• Apply a built-in Cell Style:
  
  • Heading 1, Heading 2, etc.
    (Home → Cell Styles)

These headings become PDF bookmarks.

---

Step 2: Force clean page breaks (important)​

For each target section:

• Click the first row
• Page Layout → Breaks → Insert Page Break

This ensures each bookmark lands neatly.

---

Step 3: Replace your hyperlinks​

Instead of linking to named ranges:

• Insert links to the page the section starts on
  (Insert → Link → Place in This Document → Page number)

---

Step 4: Export correctly​

• File → Save As → PDF
• Click Options
• Check:
  
  • Create bookmarks using: Headings
• Save

---

Result​

✔ Clickable links in the PDF
✔ Sidebar bookmarks for navigation
✔ No broken links
✔ No VBA
✔ Works reliably in Acrobat, Edge, Chrome

 

[snb]

Interessant, maar in Excel 2010 ontbreekt de optie 'Create Bookmarks...'

 

[HSV]

Ik heb het ooit zo gedaan.