title: How to call user-defined function in Personal.xlsb?
body: <p>I'm trying to get the <code>.NumberFormat</code> of a cell.</p>
  <p>I tried putting the UDF both in the project where I'm using it and in my <code>PERSONAL.XLSB</code>.<br />
  I tried declaring them as both <code>Function</code> and <code>Public Function</code>, and neither are recognised. I get a #NAME? error.</p>
  <p>The function, in PERSONAL.XLSB.</p>
  <pre><code>Public Function GetFormat(r As Range) As String
      GetFormat = r.NumberFormat
  End Function
  </code></pre>
  <p>I've gone through <a href="http://dmcritchie.mvps.org/excel/getstarted.htm" rel="nofollow noreferrer">this page</a>. I can't figure out what's missing.</p>
  <p>EDIT: It works if I specify <code>PERSONAL.XLSB!GetFormat</code>, but I'd prefer to be able to call it with just the <code>=GetFormat([CELL])</code> format.</p>