Determining new category number

[Matt]

Is there a way to determine the category number of a new
function category I've created for UDF's?

I would like to distribute an add-in with my UDF's grouped
together in a new category. But depending on add-ins
already installed on a user's pc, the category number for
the new category can vary. So, I would like to be able to
run a macro that reads the new category's number, then
assigns the udf to that category. Hope I haven't made
this sound to convulted.

Thanks,
Matt

 

[Gord Dibben]

Matt

As an alternative have a look at Laurent Longre's FUNCUSTOMIZE.DLL

This free add-in allows to customize VBA user-defined functions in Excel's
function wizard :

- add descriptive text to each argument
- store user-defined functions in a new category (for instance "My Functions")

http://longre.free.fr/english/index.html

Easy to use and comes with full Help/Instructions.

Gord Dibben XL2002