XL97: Error When Function Contains a Breakpoint (158687)
The information in this article applies to:
- Microsoft Excel 97 for Windows
- Microsoft Word 97 for Windows
- Microsoft PowerPoint 97 for Windows
- Microsoft Binder 97 for Windows
This article was previously published under Q158687 SYMPTOMS
In Microsoft Excel, when you type or edit a formula in a worksheet, you
may receive the following error message:
This program has performed an illegal operation and will be shut down.
If the problem persists, contact the program vendor.
If you click Details, you receive an error message similar to one or more
of the following:
EXCEL caused an invalid page fault in module EXCEL.EXE at
014f:300960ef.
BINDER caused an exception 6bfH in module KERNEL32.DLL at
014f:bff9a080.
When these messages appear, the Microsoft Office 97 programs may close or
stop responding.
CAUSE
This problem may occur when all of the following conditions are true:
NOTE: A breakpoint may be set manually by using the Toggle Breakpoint
command on the Debug menu or programmatically by using the Stop statement.
WORKAROUND
To prevent this problem from occurring, do not set a breakpoint in the
custom function. If you need to pause or break your macro at run-time, use
the MsgBox function or the End statement instead.
For more information about the MsgBox function, click the Index tab in
Help, type the following text
and then double-click the selected text to go to the "MsgBox function"
topic.
STATUS
Microsoft has confirmed this to be a problem in the Microsoft products
listed at the beginning of this article.
Modification Type: | Minor | Last Reviewed: | 10/10/2006 |
---|
Keywords: | kbbug kbdtacode kberrmsg kbProgramming KB158687 |
---|
|