title: Cannot run the macro
body: <p>I have encountered a problem in the macro below</p>
  
  <pre><code>Sub RefreshAction()
      Range("b7").Select
      Application.Run "RefreshCurrentSelection"
      Application.OnTime (Now() + TimeValue("00:00:05")), "thisworkbook.Action"
  End Sub
  </code></pre>
  
  <p>The cell refreshes when I run the macro the first time but I get the error message immediately after</p>
  
  <p>Message: Cannot run the macro "C\Desktop\XYZ.xlsm'!thisworkbook.Action'. The macro may not be available in this workbook or all macros may be disabled.</p>
  
  <p>I have already gone through "Trust Center->Trust Center Settings->Macro Settings->Enable all macros and it didn't work.</p>
  
  <p>The "Trust access to VBA project object model" box is also clicked.</p>