title: Excel VBA macro runs from the VBA editor but not from the Macro window
body: <p>I have a macro written in excel that has now stopped being able to run from the Macro window in the main excel window. It runs fine when I start it from the editor itself and I have another macro in the same file that also runs fine, and displays properly in the macro window. Please see picture.
  <a href="https://i.stack.imgur.com/5avMQ.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5avMQ.png" alt="Macro not running"></a></p>
  
  <p><a href="https://i.stack.imgur.com/ZlRFD.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ZlRFD.png" alt="enter image description here"></a></p>
  
  <p>If anyone has any idea why this is happing I'd be grateful, its a pain to run at the minute...</p>
  
  <p>Running excel 2013 if that matters.</p>
  
  <p>Thanks!</p>
  
  <p><strong>EDIT</strong></p>
  
  <p><a href="https://i.stack.imgur.com/5iAq2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5iAq2.png" alt="enter image description here"></a></p>
  
  <p>Both subs are stored in the same file, the one highlighted in the picture above</p>
  
  <p><strong>Edit 2</strong></p>
  
  <p>The issue has weirdly resolved itself now, I did absolutely nothing and it fixed itself. would still like to know the cause</p>