Excel Insert Function form
 

Is there a way to create a custom category in the "Insert Function"
form?
and
Is there a way to get rid of the PERSONAL.XLS!FUNCTIONNAME from Public
Functions that reside in the personal.xls workbook?

What I want to achieve is to have all my custom functions under one
category as the user defined category is full with Adobe PDF functions.

Is this possible?
How?

Excel Insert Function form
 

--------------------------------------------------------
Is there a way to get rid of the PERSONAL.XLS!FUNCTIONNAME from Public
Functions that reside in the personal.xls workbook?
Sounds like a custom function of yours. Why not get into the VBE, go to
Personal.xls and delete the function FunctionName()?
--------------------------------------------------------
What I want to achieve is to have all my custom functions under one
category
Check out the Microsoft Knowledgebase...
How to Add a New Category to Function Category List
http://support.microsoft.com/default.aspx?kbid=137526
--------------------------------------------------------
HTH,
--
Gary Brown

If this post was helpful, please click the ''Yes'' button next to ''Was this
Post Helpfull to you?''.


"Santa-D" wrote:

Is there a way to create a custom category in the "Insert Function"
form?
and
Is there a way to get rid of the PERSONAL.XLS!FUNCTIONNAME from Public
Functions that reside in the personal.xls workbook?

What I want to achieve is to have all my custom functions under one
category as the user defined category is full with Adobe PDF functions.

Is this possible?
How?

Excel Insert Function form
 

See Laurent Longre's site for creating new categories and adding arguments and
descriptions to UDF's

http://xcell05.free.fr/

Check out FUNCUSTOMIZE

MOREFUNC is also a very handy Add-in with 60+ added functions.

Make a copy of Personal.xls and save as an add-in.

You will see just the UDF name without the workbook prefix

You can also just use the UDF in your formulas without the workbook prefix.


Gord Dibben MS Excel MVP

On 27 Jun 2006 00:12:02 -0700, "Santa-D" wrote:

Is there a way to create a custom category in the "Insert Function"
form?
and
Is there a way to get rid of the PERSONAL.XLS!FUNCTIONNAME from Public
Functions that reside in the personal.xls workbook?

What I want to achieve is to have all my custom functions under one
category as the user defined category is full with Adobe PDF functions.

Is this possible?
How?