Microsoft Office Tutorials and References
In Depth Information
16.1.3 Members that Enable Excel Features
This property determines whether animated insertion and deletion is enabled. When
animation is enabled, inserted worksheet rows and columns appear slowly and deleted
worksheet rows and columns disappear slowly. The default value is False .
EnableAutoComplete property (R/W Boolean)
This property determines whether Excel's AutoComplete feature is enabled; its default
value is True .
EnableCancelKey property (R/W Long)
This property controls how Excel handles the Ctrl -Break or Esc key combinations during
a running procedure. It can be one of the following XlEnableCancelKey constants:
xlDisabled = 0
xlInterrupt = 1
xlErrorHandler = 2
The meanings of these constants follow:
Trapping is disabled (the keystrokes are ignored).
The running procedure is interrupted by the display of a dialog box that enables the user
to either debug or end the procedure. This is the default value.
The keystroke interrupt is sent to the running procedure as an error that is trappable by an
error handler using the On Error GoTo statement. The error code is 18.
Note that this property can be dangerous and should be used with great circumspection. In
particular, if you set the property to xlDisabled , then there is no way to interrupt an
infinite loop. Similarly, if you set the property to xlErrorHandler but your error
handler returns using the Resume statement, there is no way to stop nonself-terminating
For these reasons, Excel always resets the EnableCancelKey property to xlInterrupt
whenever Excel returns to the idle state and there is no code running.
EnableEvents property (R/W Boolean)
This property is True (its default value) if events are enabled for the Application object.
EnableSound property (R/W Boolean)
This property enables and (mercifully) disables sounds for Microsoft Office. The default
value is False .