Determining new category number

  • Thread starter Thread starter Matt
  • Start date Start date
M

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
 
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
 
Back
Top