Add user-defined function UDF to built-in category in Excel

Question

When I add a public function to an Excel standard code package, it appears in the "User Defined" category of the Insert Function wizard.

Is there any way to:

1. Keep the function public (so it may be called from other modules) but hide it from the Excel function wizard.
2. Make the function appear in a built-in category (e.g., "Financial", "Statistical", "Logical").
3. Create my own category (e.g., "Nonsensical") and have my function appear there.

I'd be interested to hear if each of the above scenarios is feasible, but I only need to be able to make one of them work.

Answer 1

Use Application.MacroOptions

This example adds a user-defined macro called TestMacro to a custom category named My Custom Category.

Function TestMacro()
    MsgBox ActiveWorkbook.Name
End Function

Sub AddUDFToCustomCategory()
    Application.MacroOptions Macro:="TestMacro", Category:="My Custom Category"
End Sub