Microsoft Office Tutorials and References
In Depth Information
18.104.22.168 RecentFiles property (Read-Only)
Interactive property (R/W Boolean)
When this property is set to False , Excel will block all input from the keyboard and
mouse except for input to dialog boxes that are displayed by code. This will prevent the
user from interfering with the currently running macro. The default value of the
Interactive property is True .
Of course, considerable care must be taken with this property. For instance, if you forget
to reset the property to True , or if your code terminates unexpectedly, the user may need
to restart Excel. Note that the Alt-F4 key combination will work to shut down Excel, but
the user will not be able to save any work. Be careful with this one!
MoveAfterReturn property (R/W Boolean)
When this property is True , its default value, the active cell will be moved as soon as the
Enter key is pressed. The MoveAfterReturnDirection property is used to specify the
direction in which the active cell will be moved. If set to False , the active cell remains
unchanged after the Enter key is pressed.
MoveAfterReturnDirection property (R/W Long)
This property returns or sets the direction in which the active cell is moved when the user
presses Enter if the MoveAfterReturn property is set to True . It can assume any one of
the following values:
xlUp = -4162
xlToRight = -4161
xlToLeft = -4159
xlDown = -4121
ReferenceStyle property (R/W Long)
This property returns or sets the style (A1 style or R1C1 style) in which Excel displays
cell references and row and column headings. It can be one of the following
xlR1C1 = -4150
xlA1 = 1
ScreenUpdating property (R/W Boolean)
When this property is True , its default value, screen updating is turned on. Since this
may slow down some display-intensive procedures considerably, you may want to
temporarily turn off screen updating.
SheetsInNewWorkbook property (R/W Long)
This property returns or sets the number of sheets that Excel automatically inserts into
ShowChartTipNames property (R/W Boolean)
When this property is True , its default value, Excel charts show chart tip names.