title: Cannot run the macro. The macro may not be availabe in this workbook
body: <p>Having an issue with VBA error 'run time 1004'. Using the following code. The macro is called from a button in Row 5, hence the subtraction. There are other buttons in rows 6, 7, 8 etc. all calling the same macro (to subsequently call a specific userform), hence the variable.</p>
  
  <pre><code>Sub Export()
      i = RowNumber - 4
  
      Reinstated = "ReinstateR" &amp; i
  
      Application.Run Reinstated
  
  End Sub
  </code></pre>
  
  <p>The macros 'ReinstateR1', 'ReinstateR2' etc. are all stored in a separate module.</p>
  
  <pre><code>Sub ReinstateR1()
  
  'Macro function etc.
  
  End Sub
  </code></pre>
  
  <p>For some reason, though, when I click the button, I get the following error message:</p>
  
  <p>"Cannot run the macro 'ReinstateR1'. The macro may not be available in this workbook or all macros may be disabled."</p>
  
  <p>All macros are enabled, the macro is in the same workbook, etc. Trust centre settings are set to disable all macros with notification, etc.</p>
  
  <p>I'm stumped. I can call the macro without the variable, but that's not the point...</p>