title: Excel VBA macro not found by worksheet, #NAME
body: <p>I'm trying to get a simple VBA function to run in an excel (.xlsm) worksheet. </p>
  
  <p>I created this function: </p>
  
  <pre><code>Function abc()
  
  abc = 2
  
  End Function
  </code></pre>
  
  <p>in Module2, and it worked. </p>
  
  <p>But after I copied the spreadsheet to another system, it now just shows "#name" as if it can't find it. The function shows up on the available list of functions however. </p>
  
  <p>This makes me think there is some kind of setting I need to enable, but I've enabled whatever I was prompted for. Any ideas? </p>