title: Excel Hyperlinks change when I move spreadsheet
body: <p>I have a spreadsheet in which I add hyperlinks to files using vba as follows:</p>
  
  <pre><code>Sheet1.Cells.Hyperlinks.Add Sheet1.Cells(1, 1), objFile.Path
  </code></pre>
  
  <p>This works fine. But if i move the spreadsheet which has the hyperlinks in it to another folder, all the hyperlinks change relative to the folder where I move the spreadsheet to.</p>
  
  <p>Is there a way to stop this happening and fixing the hyperlinks path.</p>
  
  <p>Thanks</p>