title: calling command button from another command button
body: <p>I am making a macro that calls from another command button to run a SQL query. When I run the code i keep getting an error message that says <code>run time error 1004. Macro's may not be available in this workbook or may not be enabled.</code> I checked to see if macros are enabled and they are enabled on all sheets. I am using the <code>application.run</code> method to do this. Any other reason besides the fact the macros are not enabled?</p>
  
  <p>Here is the line of code I am using.</p>
  
  <pre><code>Application.Run "'CostBreakDownbyWorkOrder-Query.xlsm'!btnRunReport_Click"
  </code></pre>