Microsoft KB Archive/213813

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

Article ID: 213813

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q213813





SUMMARY
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.



MORE INFORMATION
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.

Additional query words: howto udf vbe XL2000

Keywords: kbdtacode kbhowto kbprogramming KB213813

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.