There is no "user defined" category in my insert function window. I
have created a few user defined functions but am unable to access
them. I always get a NAME error.

Have you stored them in a standard code module?

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"K_urac" wrote in message
ups.com...
There is no "user defined" category in my insert function window. I
have created a few user defined functions but am unable to access
them. I always get a NAME error.

The following information is already available in the on-line help of
Microsoft Excle.

Making your custom functions available anywhere

To use a custom function, the workbook containing the module in which you
create the function must be open. If that workbook is not open, you get a
#NAME? error when you try to use the function. Even if the workbook is open,
if you use the function in a different workbook, you must precede the
function name with the name of the workbook in which the function resides.
For example, if you create a function called Discount in a workbook called
Personal.xls, and you call that function from another workbook, you must
write =personal.xls!Discount(), not simply =Discount().

You can save yourself some keystrokes (and possible typing errors) by
selecting your custom functions from the Insert Function dialog box. (Your
custom functions appear in the User Defined category.) An easier way to make
your custom functions available at all times is to store them in a separate
workbook and then save that workbook as an add-in (an XLA file) in your
XLStart folder. (The XLStart folder is a subfolder of the folder containing
your Excel files. When you start Excel, the program opens any documents it
finds in XLStart.) To save a workbook as an add-in, choose File, Save As (or
File, Save). Then choose Microsoft Excel Add-in from the Files Of Type list.

If your user-defined functions are stored in an XLA file that is present in
memory, you don't have to specify the name of that file when you call a
function. If the XLA file is saved in your XLStart folder, it will be present
in memory whenever you run Excel.

Challa Prabhu

"K_urac" wrote:

There is no "user defined" category in my insert function window. I
have created a few user defined functions but am unable to access
them. I always get a NAME error.

Is there a way that a user defined function can reside within the file itself?

If i email an excel sheet to another person and it contains user defined
functions, they don't work for the recipient. Is there a way round this?
--
Andrew


"challa prabhu" wrote:

The following information is already available in the on-line help of
Microsoft Excle.

Making your custom functions available anywhere

To use a custom function, the workbook containing the module in which you
create the function must be open. If that workbook is not open, you get a
#NAME? error when you try to use the function. Even if the workbook is open,
if you use the function in a different workbook, you must precede the
function name with the name of the workbook in which the function resides.
For example, if you create a function called Discount in a workbook called
Personal.xls, and you call that function from another workbook, you must
write =personal.xls!Discount(), not simply =Discount().

You can save yourself some keystrokes (and possible typing errors) by
selecting your custom functions from the Insert Function dialog box. (Your
custom functions appear in the User Defined category.) An easier way to make
your custom functions available at all times is to store them in a separate
workbook and then save that workbook as an add-in (an XLA file) in your
XLStart folder. (The XLStart folder is a subfolder of the folder containing
your Excel files. When you start Excel, the program opens any documents it
finds in XLStart.) To save a workbook as an add-in, choose File, Save As (or
File, Save). Then choose Microsoft Excel Add-in from the Files Of Type list.

If your user-defined functions are stored in an XLA file that is present in
memory, you don't have to specify the name of that file when you call a
function. If the XLA file is saved in your XLStart folder, it will be present
in memory whenever you run Excel.

Challa Prabhu

"K_urac" wrote:

There is no "user defined" category in my insert function window. I
have created a few user defined functions but am unable to access
them. I always get a NAME error.

You can store the UDF in a general module in the workbook in question.

Alt + F11 then CTRL + r.

Select you workbook/project and InsertModule.

Place the UDF in that module and Save the workbook.

The UDF will stay with the workbook.


Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 06:40:01 -0800, slymeat .(donotspam)
wrote:

Is there a way that a user defined function can reside within the file itself?

If i email an excel sheet to another person and it contains user defined
functions, they don't work for the recipient. Is there a way round this?