Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
thungerford
 
Posts: n/a
Default no user-defined category

My user-defined functions are not available to me nor do I have a user
-defined category in the function list box.
  #2   Report Post  
Posted to microsoft.public.excel.misc
Arvi Laanemets
 
Posts: n/a
Default no user-defined category

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   Report Post  
Posted to microsoft.public.excel.misc
Arvi Laanemets
 
Posts: n/a
Default no user-defined category

Sorry!


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


Arvi Laanemets


  #4   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben
 
Posts: n/a
Default no user-defined category

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
User defined functions without using VBA. [email protected] Excel Worksheet Functions 0 June 13th 06 06:49 PM
User defined charts Ajay Charts and Charting in Excel 0 January 17th 06 01:58 PM
About User Defined Functions linzhang426 Excel Worksheet Functions 4 October 17th 05 10:27 PM
Default User Defined Functions - How? flycast Excel Discussion (Misc queries) 4 May 26th 05 05:26 AM
User defined charts- font size too small Bill B Charts and Charting in Excel 1 December 30th 04 07:23 PM


All times are GMT +1. The time now is 05:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"