The official method from Microsoft is as follows. I'm afraid we've not
found a better method!
XL: How to Add a New Category to Function Category List
Last reviewed: February 20, 1998
Article ID: Q137526
The information in this article applies to:
Microsoft Excel for Windows, versions 5.0, 5.0c
Microsoft Excel for the Macintosh, version 5.0
Microsoft Excel 98 Macintosh Edition
Microsoft Excel for Windows NT, version 5.0
Microsoft Excel for Windows 95, version 7.0
Microsoft Excel 97 for Windows
To manually create a custom category for a user-defined function that
you write in Microsoft Visual Basic for Applications, you must insert a
Microsoft Excel 4.0 macro sheet before you create the category.
To create a custom category, follow these steps:
In Microsoft Excel 97, right-click a sheet tab in the workbook and click
Insert. In Microsoft Excel 98 Macintosh Edition, hold the Control key
and click a sheet tab in the workbook and click Insert. Click MS Excel
4.0 Macro and click OK to add a macro sheet to the workbook.
In Microsoft Excel 5.0 and 7.0, point to Macro on the Insert menu, and
click MS Excel 4.0 Macro to add a macro sheet to the workbook.
On the Insert menu, point to Name, and then click Define. Under Macro,
In the Name box, type "TEST1" (without the quotation marks).
In the Category box, replace "User Defined" with the new category, and
then click OK.
Microsoft Excel adds the new category to the list. After you add one or
more custom functions to the new category, you can delete the "TEST1"
function name. When you do this the new category remains. If you delete
the Microsoft Excel 4.0 macro sheet, functions already assigned to the
custom category remain in that category; however, you cannot assign a
new function to that category after you delete the macro sheet.
Excel 97 for Windows and Excel 98 Macintosh Edition
You cannot add a user-defined function to a specific category by
selecting the function in a dialog box. You must use a macro to specify
a category for the function. For additional information, please see the
following article in the Microsoft Knowledge Base:
TITLE : Options not Available in Macro Options Dialog Box
Microsoft Excel 5.0 and 7.0
To specify a category for a user-defined function, follow these steps:
With a module sheet active, press F2 to start the Object Browser
Select the workbook in the Libraries/Workbooks list.
Select the custom function in the Methods/Properties list, and then
Select the category in the Function Category list, and then click OK.
Click Close to close the Object Browser.
"User's Guide 2," version 4.0, Chapter 5, "To Name a custom function,"
For additional information, please see the following article(s) in the
Microsoft Knowledge Base:
TITLE : XL: Custom Function in the Wrong Category in Function
Additional query words: 5.00 5.00c 7.00 7.00a 8.00 howto udf vbe
Keywords : kbprg PgmHowto
Version : WINDOWS: 5.0, 5.0c, 7.0, 97; MACINTOSH: 5.0, 5.0a, 98
Platform : MACINTOSH WINDOWS
Issue type : kbhowto
THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS
IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES,
EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY
AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT
CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER
INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS
PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS
SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME
STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR
CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT
Last reviewed: February 20, 1998
> [log in to unmask][SMTP:Anasagasti_Santiago/mad
>[log in to unmask]]
>Sent: 10 March 1998 09:56
>To: [log in to unmask]
>Subject: Adding a new function category
>Madrid March 10,1998
>I would like to know if there is any way to add a new function category
>to the function wizard(insert menu) because I want to input my VBA
>functions in this category. I know that is possible to assign the
>function to a category that already exists but I would like to create my
>Thanks for your help