title: Cannot run the macro... the macro may not be available in this workbook
body: <p>I am trying to call a sub on a different worksheet but I got a run time error message. </p>
  
  <p>Specifically, I have two worksheets and multiple VBA sub s in those worksheets. In one of the VBA Project (say workbook1.xlsm), I have the following code:</p>
  
  <pre><code>Sub AnalysisTableMacro()
  Workbooks("Python solution macro.xlsm").Activate
  Application.Run "Python solution macro.xlsm!.PreparetheTables"
  End Sub
  </code></pre>
  
  <p>But I got the following error. The macros on both worksheets are enabled. In both worksheets, the subs are in Module1. </p>
  
  <blockquote>
    <p>Cannot run the macro 'Workbook.xlsm!PrepareTheTables'. The macro may not be available in >this workbook or all macros may be disabled.</p>
  </blockquote>
  
  <p>I also tried <code>Application.Run "Python solution macro.xlsm!Module1.PreparetheTables"</code> but did not work.</p>