title: Disable "update links message" when opening MS Excel via VBA Macro
body: <p>I'm doing an auto-run macro, but it is password protected. After I removed all the passwords, it can save the file in a different format.</p>
  
  <p>The thing is that MS Excel displays a Popup Message about "update links automatically". I Tried to disable all settings from MS Excel options but the dialog still appearing.</p>
  
  <p>So, I was thinking to add some code to avoid that popup.</p>
  
  <p>Here is my code:</p>
  
  <pre><code>Sub Auto_Open()
      Workbooks.Open "C:\Test\WorkbookTest.xlsx"
      ActiveWorkbook.UnprotectSharing ("galleta")
      ActiveSheet.Unprotect ("galleta")
      ChDir "C:\Users\user\Desktop\Reportes"
      Sheets("BES").Select
      ActiveSheet.Unprotect ("galleta")
      Sheets("BE800").Select
      ActiveSheet.Unprotect ("galleta")
      Sheets("BECM").Select
      ActiveSheet.Unprotect ("galleta")   
      ActiveWorkbook.SaveAs Filename:= _
          "C:\Users\user\Desktop\Reportes\test.mht", FileFormat:= _
          xlWebArchive, CreateBackup:=False
  End Sub
  </code></pre>
  
  <p>I placed my autorun with the password thing code because it may help to someone.</p>
  
  <p>Other data: </p>
  
  <ul>
  <li>Office 2007,</li>
  <li>Windows Server 2008 R2. </li>
  </ul>
  
  <p>The message is appearing to protect the user's platform, but may be we can configure the user preference forehand via <a href="/questions/tagged/vba" class="post-tag" title="show questions tagged 'vba'" rel="tag">vba</a>.</p>
  
  <p>Thank you guys.</p>