title: How to "update" a workbook instead of reopening it(using VBA macros)?
body: <p>I'm having problems with my below code:</p>
  
  <pre><code>Private Sub Worksheet_BeforeDoubleClick(ByVal...
  Application.ScreenUpdating = False
  Set wbks = Workbooks.Open("\\whatever\whatever.xlsx")           
  wbks.Sheets("Control").Activate
  ActiveSheet.Range("A3").Select 
  Application.ScreenUpdating = True
  ...
  </code></pre>
  
  <p>As you can see, it opens a workbook everytime I double click a certain cell.
  The problem is: After the second time I double click I'm getting the annoying message:</p>
  
  <p>"'Filename.xlsx' is already open. Reopening will cause any changes you made to be discarded..."</p>
  
  <p>¿How can I turn this message off(since no changes were made), and if possible, make the target workbook gets "updated" after every double click instead of "re-open"? </p>