Microsoft KB Archive/240902

= INFO: Setting ReturnValue to False Does Not Cancel Spreadsheet Event =

Article ID: 240902

Article Last Modified on 7/27/2001

-

APPLIES TO


 * Microsoft Office Spreadsheet Component 9.0 1.0

-



This article was previously published under Q240902



SUMMARY
The SpreadSheet Web component supports events. Event procedures have a parameter for a SpreadsheetEventInfo object; this object contains information about the event. The documentation states that you can "cancel" some events by setting the ReturnValue of the SpreadsheetEventInfo object to False. This article describes which events can and cannot be canceled by setting ReturnValue to False.



MORE INFORMATION
The following events of the SpreadSheet Web component can be canceled by setting ReturnValue to False:
 * BeforeCommand
 * StartEdit
 * EndEdit

The following events cannot be canceled by setting ReturnValue to False:


 * Calculate **
 * CancelEdit
 * Change **
 * Click
 * Command
 * DblClick **
 * KeyDown
 * KeyPress
 * KeyUp
 * MouseDown
 * MouseOut
 * MouseOver
 * MouseUp
 * SelectionChange
 * SelectionChanging
 * ViewChanging **

** See the following section for more details.