| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Having User Defined functions in their own Insert Function category?
Try looking he
http://xcell05.free.fr/ -- Regards, Tom Ogilvy "Don Wiss" wrote in message ... I'm using xl 2002. I'm following this page: http://www.ozgrid.com/VBA/udf-cat-description.htm It shows a function similar to this, with the Category argument being fed a description for a new category. When running it I get a 1004 error. Sub AddCategoryDescription2() Application.MacroOptions Macro:="GetAbbrev", _ Description:="Get state abbreviation for spelled out state.", _ Category:="CalcILF" End Sub But then if I change to this it runs, and moves my GetAbbrev function from the User Defined category to #16, which happens to be engineering. And the description is added. Sub AddCategoryDescription() Application.MacroOptions Macro:="GetAbbrev", _ Description:="Get state abbreviation for spelled out state.", _ Category:=16 End Sub Reading the help file for MacroOptions it states that the argument for Category must be an integer. So how does one create a new category, where I want to put all my UDFs? Then it would be nice if I could have the add-in itself, when loaded, create the category and put its functions in it with descriptions. Don <www.donwiss.com (e-mail link at home page bottom). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| i cant see my user defined functions in function list | Excel Worksheet Functions | |||
| no user-defined category | Excel Discussion (Misc queries) | |||
| Insert Function wizard for User Defined Functions | Excel Programming | |||
| User functions and the Insert-Function dialogue | Excel Programming | |||
| Comining lots of functions into one User defined function | Excel Programming | |||
Linear Mode
