XL97: Deleted 4.0 Macro Function Appears in Function Wizard

• Microsoft Excel 97 for Windows

SYMPTOMS

In Microsoft Excel 97, when you delete a function name that was created in a Microsoft Excel 4.0 macro sheet, it may still appear in the Function Wizard. If you select it and try to insert it you may get the following error message:

This program has performed an illegal operation and will be shut down.
If the problem persists, contact the program vendor.

EXCEL caused an invalid page fault in module EXCEL.EXE at 0137:3003b352

CAUSE

This behavior may occur if the following conditions are true:

• A name is defined on a Microsoft Excel 4.0 macro sheet.


-and-


• The name is defined as a Function macro.


-and-


• The Microsoft Excel 4.0 macro function name has been deleted or the Microsoft Excel macro sheet has been deleted.

WORKAROUND

To work around this problem, redefine the name so that it is not a function macro, and then delete the name. To do this, follow these steps:

1. Switch to the Microsoft Excel 4.0 macro sheet.



2. On the Insert menu, point to Name and click Define.



3. Select the Macro Function name in the Names In Workbook list and click None under the Macro options. Click OK.



4. On the Insert menu, point to Name and click Define.



5. Select the Macro Function name in the Names In Workbook list and click Delete. Click OK.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

MORE INFORMATION

In order to create custom category names for user-defined functions in Microsoft Excel, you must use a Microsoft Excel 4.0 macro sheet.

For additional information about creating custom category names for user- defined functions, please see the following article in the Microsoft Knowledge Base:

Q137526 XL: How to Add a New Category to Function Category List

Additional query words:

Keywords : kbprg xlvbainfo
Version : WINDOWS:
Platform : WINDOWS
Issue type : kbbug