XL2000: How to Add a New Category to Function Category List

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:

1. In Microsoft Excel 2000, right-click a sheet tab in the workbook and then click Insert.
2. Click MS Excel 4.0 Macro, and then click OK to add a macro sheet to the workbook.
3. On the Insert menu, point to Name, and then click Define. Under Macro, click Function.
4. In the Name box, type TEST1.
5. In the Category box, replace User Defined with the new category name, 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.