title: ScreenUpdating not working when opening a file
body: <p>So I'm creating a library of commonly used macros for excel for my Excel 2011 for Mac. I'm running a couple of tests to make sure it's working properly. The biggest problem I'm running into is that when I run the code (despite having ScreenUpdating set to False), it visibly opens the library file while it runs the macro.</p>
  
  <p>To make sure this is efficient going forward, I want to prevent that from happening. Here is currently what my code looks like: </p>
  
  <pre><code>Sub findRow()
  Application.ScreenUpdating = False
  Application.DisplayAlerts = False
  Application.EnableEvents = False
  
  Dim bk As Workbook
  Dim result As Long
  Dim aWB As Workbook
  Dim aWS As Worksheet
  Set aWB = ActiveWorkbook
  Set aWS = ActiveWorkbook.ActiveSheet
  
  With Application
      .ScreenUpdating = False
      .DisplayAlerts = False
      .EnableEvents = False
  Set bk = .Workbooks.Open _
  (ActiveWorkbook.Path &amp; ":library.xlsm")
  'Set bk = ActiveWorkbook.Path &amp; ":library.xlsm"
  End With
  
  'Workbooks.Open (ActiveWorkbook.Path &amp; ":library.xlsm")
  'Workbooks.Open (bk)
  result = Application.Run("'" &amp; ActiveWorkbook.Name &amp; "'!findFirstEmptyRow", aWS)
  ActiveWorkbook.Close
  Cells(result, 1) = result
  
  Application.ScreenUpdating = True
  Application.DisplayAlerts = True
  Application.EnableEvents = True
  End Sub
  </code></pre>
  
  <p>There is quite a few redundancies in there as well as commented out lines that show various things I've tried. Originally I simply ran code that set Application.X settings to False, opened the Workbook, ran the macro, and closed. </p>
  
  <p>Hopefully someone can come up with a reason for ScreenUpdating not taking effect when I open a new Workbook. </p>