The problem was, I wanted the URL to change dynamically with a formula and I couldn't put a formula in the Excel dialog box. This way when the PDF is generated on print the file is saved with the hyperlink available in the pdf.
Similar to when you right click on a sheet and manually insert the hyperlink through the Windows Excel dialog box. So, I ended up having to use VBA to write the http URL address directly to the property of the cell on the sheet where I wanted the hyperlink. When passed directly from sheet to sheet, of course it didn't work. Within it, I wanted the hyperlinks to show up and change dynamically based on a vlookup table. I also have a sheet that is used for formatting a dynamic presentation and I wanted it to print in PDF format to deliver to a customer. The thread helped me find the answer when I realized what the workarounds that were suggested were doing.
0 kommentar(er)
