title: When attempting to run a function there is a prompt to select a macro
body: <p>I'm trying basic stuff from the book for dummies to see what it does.</p>
  <pre class="lang-vb prettyprint-override"><code>Function CubeRoot(number)
      CubeRoot = number ^ (1 / 3)
  End Function
      
  Function Change(Cell, NewText)
      Cell.Comment.Text NewText
  End Function
  </code></pre>
  <p>Both prompt me to select a macro. It is trying to suggest an unrelated sub.</p>
  <pre class="lang-vb prettyprint-override"><code>Sub ShowMessage()
      MsgBox &quot;THats all folks&quot;  
  End Sub
  </code></pre>