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

You will experience this behavior if the following conditions are true:

• A name was defined on an Microsoft Excel 4.0 Macro sheet.

      -and-
  

• The name was defined as a Function macro.

      -and-
  

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

WORKAROUND

To work around this problem, re-define the name not to be a function macro and then delete the name. To do this, use the following procedure:

Steps to Safely Delete an Microsoft Excel 4.0 Macro Function

1. Activate 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.

6. You can now safely delete the Microsoft Excel 4.0 macro sheet if desired

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

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

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

   ARTICLE-ID: Q137526
   TITLE     :XL: How to Add a New Category to Function Category List

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