no user-defined category

[Guest]

My user-defined functions are not available to me nor do I have a user
-defined category in the function list box.

 

[Arvi Laanemets]

Hi

How did you define them?

UDF's code must be in ThisWorkbook's module (in same workbook, or in your
Personal Macro Workbook - Personal.xls);
UDF's code can't have any activities in workbook, like changing cell
entries, or changing active sheet/cell, or changing cell formats, etc.;
UDF's return the value from variable with same name as UDF.

 

[Arvi Laanemets]

Sorry!


.....
UDF's code must be in Workbook's module (in same workbook, or in your
Personal Macro Workbook - Personal.xls);
.....


Arvi Laanemets

 

[Gord Dibben]

Or in an Add-in(*.xla) loaded through Tools>Add-ins.


Gord Dibben MS Excel MVP