title: macro opening other worksheets not working for other User
body: <p>I have recorded a macro that basically opens up other worksheets and copy and pastes data into them before saving and closing them. It works perfectly for me but when a colleague tries to run the same macro with the same files it fails. </p>
  
  <p>It opens up the first worksheet but then stops at the first command of - Application.Run "ConnectChartEvents. Any ideas why? </p>
  
  <pre><code>ChDir "\\dstm8307vpfs\EQData\EQUITYSWAPS\Client Folders\Proshares"
      Workbooks.Open Filename:= _
          "\\dstm8307vpfs\EQData\EQUITYSWAPS\Client Folders\Proshares\INTL_SWAPMTM_UBS.xlsm" _
          , UpdateLinks:=0
      Application.Run "ConnectChartEvents"
      ActiveWindow.ScrollWorkbookTabs Position:=xlLast
      Sheets("Allocations").Select
      Range("D3:D38").Select
      Selection.ClearContents
      ActiveWindow.ScrollWorkbookTabs Position:=xlFirst
      Sheets("UltraShort FTSE Xinhua China 50").Select
      Range("G1048576").Select
      Selection.End(xlUp).Select
      ActiveCell.Offset(1, 0).Range("A1").Select
      ActiveCell.FormulaR1C1 = "='[DIVS - test.xlsm]Sheet1'!R13C2"
      ActiveCell.Select
      Selection.Copy
      Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
          :=False, Transpose:=False
      Application.CutCopyMode = False
      Sheets("Execution Commissions").Select
      ActiveWorkbook.Save
      ActiveWindow.Closesheet
  </code></pre>