Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add a function category
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I add a function category
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 "Sam Wilson" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I switch to my custom Function category ? | Excel Programming | |||
How to assign a Category to a custom function? | Excel Programming | |||
How to make a new function category? | Excel Programming | |||
Add a category to the Insert-Function category list | Excel Programming | |||
Adding a category to the Function Wizard | Excel Programming |