How do I add a function category

[Sam Wilson]

Hi all,

I'm using Excel 2003 and want to add a function category to the Insert
Function wizard so that user of the add-in can select my UDFs from there.

Eg, after All, Most Recently Used, Financial, Date & Time, Math & Trig etc
I'd like to see "Blah Blah Functions" as well as "User Defined Functions"

Cheers,

Sam

 

[Sam Wilson]

Scratch that question, I've found it: this creates a new category

Public Function test(ByVal mystring As String) As String
test = mystringEnd Function

Sub AddToCategory()
Application.MacroOptions Macro:="Test", Category:="Blah Blah"
End Sub