User Defined Function use any worksheet
 

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
--
LJW

User Defined Function use any worksheet
 

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

"Babylynn" wrote:

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
--
LJW

User Defined Function use any worksheet
 

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

On Wed, 1 Apr 2009 07:25:26 -0700, Babylynn
wrote:

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