User Defined Function use any worksheet

[Babylynn]

I downloaed SpellNumber, into visual basic, which converts numbers to text
from online. It works fine in the one workbook, i loaded it to. But the
function doesn't appear available if i open another workbook. Is there
something I need to turn on in add ins? or is this just the way it works? I
am not a programmer

 

[Eduardo]

HI,
UDF works only in the workbook you entered it, you will have to enter it
again in the other workbook for it to work

 

[Gord Dibben]

Store the spellnumber macro in your Personal Macro Workbook.

Personal.xls or Personal.xlsx

Or store it in a new workbook which you save as an Add-in


Gord Dibben MS Excel MVP