EnableCancelKey Property Uses xlDisabled Constant (149252)
The information in this article applies to:
- Microsoft Excel for Windows 95 7.0a
- Microsoft Excel for Windows 5.0c
- Microsoft Excel for Windows NT 5.0
- Microsoft Excel for the Macintosh 5.0a
This article was previously published under Q149252 SYMPTOMS
The following two paragraphs about Microsoft Excel can be found on page 187
of the Microsoft Excel "Visual Basic User's Guide" and page 137 of
"Microsoft Excel/Visual Basic Programmer's Guide":
You can also ignore user interrupts completely by setting the
EnableCancelKey property to xlIgnore. In this condition, Microsoft
Excel ignores all attempts by the user to interrupt the running
procedure.
Note Use caution when disabling or ignoring user interrupts. It is
possible to write code that never returns or ends. If you disable
interrupts by setting the EnableCancelKey property to xlIgnore, or if
you always use the Resume statement to return from a trapped error,
your procedure will not return control to the user.
REFERENCES
"Microsoft Excel/Visual Basic Programmer's Guide," p.136-138, Microsoft
Press, 1995.
Microsoft Excel "Visual Basic User's Guide," version 5.0, p. 186-187.
For more information about the EnableCancelKey method in Microsoft Excel
version 7.0, click Answer Wizard on the Help menu and type:
For more information about Error Handling in Microsoft Excel version
5.0, click the Search button in Help and type:
Modification Type: | Minor | Last Reviewed: | 10/11/2006 |
---|
Keywords: | kbdtacode kbfix kbProgramming KB149252 |
---|
|