Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My user-defined functions are not available to me nor do I have a user
-defined category in the function list box. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 ( My real mail address: arvi.laanemets<attarkon.ee ) "thungerford" wrote in message ... My user-defined functions are not available to me nor do I have a user -defined category in the function list box. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Sorry!
..... UDF's code must be in Workbook's module (in same workbook, or in your Personal Macro Workbook - Personal.xls); ..... Arvi Laanemets |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Or in an Add-in(*.xla) loaded through ToolsAdd-ins.
Gord Dibben MS Excel MVP On Fri, 16 Jun 2006 08:58:51 +0300, "Arvi Laanemets" wrote: Sorry! .... UDF's code must be in Workbook's module (in same workbook, or in your Personal Macro Workbook - Personal.xls); .... Arvi Laanemets |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
User defined functions without using VBA. | Excel Worksheet Functions | |||
User defined charts | Charts and Charting in Excel | |||
About User Defined Functions | Excel Worksheet Functions | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
User defined charts- font size too small | Charts and Charting in Excel |