Leading the way in Microsoft Office Development

Step 1 - How to create a new Function Category ?

By default any user defined functions will be added to the User Defined category in the (Insert > Functions) dialog box.

It is possible to create a new category to store your functions but it involves using an Excel 4.0 Macro.

Step 2 - Insert an Excel 4.0 Macro worksheet

Right click a worksheet and select the Insert button.

Select "MS Excel 4.0 Macro" and click OK.

This will insert a new Excel 4.0 Macro worksheet into your workbook (or add-in).

Step 3 - Add the new Function Category

Select (Insert > Name > Define) and in the bottom right click "Function".

Type the name of your category in the "Names in workbook" box.

The new category will be added to the list in the (Insert > Functions) dialog box.

Once you have added at least one function to this new category you can actually delete the Macro 4.0 worksheet.

You will not be able to add any more functions to the category once the Macro 4.0 worksheet has been deleted.