Hi,
I have a quite large workbook, where i have dynamic links to different sheets.This all works well within excel, but converting to pdf....
I would like to have a macro that reads these link and writes the static version to a different cell or object.
The reason for this, is that i need to create a pdf from my workbook and have these links working within the pdf document.
using the built in, 'insert link'->'within document'->selecting the sheet, works fine when converting to pdf. So i'm hoping a macro could help me automate this process. manually fixing the links this way is not an option.
Thanks,
Frank
The example creates a hyperlink in c1 that changes in relation a1. I would like to have a macro that convert this link to a pdf friendly link that attaches to the textbox(click)
Bookmarks