title: Calling macro with Application.Run gives an error 1004
body: <p>I can't find the cause of the error 1004 returned by the Application.Run command.</p>
  
  <pre><code>Sub Called()
    MsgBox "Yes"
  End Sub
  
  Sub Caller()
    Call Called ' works
    subName = "Called"
    Application.Run Application.ActiveWorkbook.Name &amp; "!" &amp; subName ' error 1004
  End Sub
  </code></pre>
  
  <p>Error description (in French):</p>
  
  <pre><code>---------------------------
  Erreur d'exécution '1004':
  Erreur définie par l'application ou par l'objet
  ---------------------------
  </code></pre>
  
  <p>Every solution I found after googling this issue leads to the same error. The Caller and Called subs are in the same "Sheet1" module.</p>
  
  <p>I'm a bit lost. I wonder if the issue is related to XL security? Or something missing in References?</p>