title: Use Personal.xlsb function in new workbook?
body: <p>I've searched around and I know how to call a function from Personal.xlsb from a VB macro, but how can I call the function to be used in a new workbook?</p>
  
  <p>Here's my function, saved in 'Module1' in my <code>Personal.xlsb</code>:</p>
  
  <pre><code>Public Function GetColumnLetter(colNum As Integer) As String
      Dim d As Integer
      Dim m As Integer
      Dim name As String
      d = colNum
      name = ""
      Do While (d &gt; 0)
          m = (d - 1) Mod 26
          name = Chr(65 + m) + name
          d = Int((d - m) / 26)
      Loop
      GetColumnLetter= name
  End Function
  </code></pre>
  
  <p>I have created a new workbook and thought I could call that just by <code>=getcolumnletter(1)</code>, but the function doesn't "populate" when I start typing <code>=...</code> </p>
  
  <p>Am I overlooking something?? How do I use this function in other workbooks, without VBA?</p>
  
  <p>Thanks for any advice!</p>