title: Programmatically creating an Excel Hyperlink to a defined name
body: <p>I have an Excel sheet where I'm using the HYPERLINK function with a defined named, i.e. <code>=HYPERLINK("#IS_Detail_CM_Entity01_Revenue",SUM($A1:$A15)</code>.  I have hundreds of these formulas in this particular workbook.  I want to publish this file as a .pdf, but the conversion process does not create links in Adobe based on the Excel Hyperlink function.</p>
  
  <p>I've tried using the "<code>ActiveSheet.Hyperlinks.Add Cell,Cell.Value</code>" code, but I can't get it to work with the defined names I'm using.</p>
  
  <p>Is there a way to do this?  I'm really not looking forward to defining each of these links manually. </p>