Excel Insert Function form

[Santa-D]

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?

[Gary L Brown]

--------------------------------------------------------
> 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
gary_brown@ge_NOSPAM.com
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?
>
>

[Gord Dibben]

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" <[email protected]> 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?