The information in this article applies to:
SYMPTOMSThe 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. MORE INFORMATION
These statements are incorrect. To make the statements correct, replace
every instance of the word "xlIgnore" with the word "xlDisabled". The
constant xlDisabled is referred to in Visual Basic online Help.
Q146864 Error Trapping with Visual Basic for Applications Q79488 Excel: ON.KEY Does Not Disable Macro Interruption with ESC Key REFERENCES
"Microsoft Excel/Visual Basic Programmer's Guide," p.136-138, Microsoft
Press, 1995.
EnableCancelKeyFor more information about Error Handling in Microsoft Excel version 5.0, click the Search button in Help and type: Error Trapping Additional query words: 5.00a 5.00c 5.0 XL7 XL5
Keywords : kbprg PgmOthr |
Last Reviewed: October 22, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |