Microsoft Office Tutorials and References
In Depth Information
18.104.22.168 RecentFiles property (Read-Only)
do this is to save the original Cursor property value before changing it, so it can be reset
to its original value.
CutCopyMode property (R/W Long)
This property returns or sets the status of Cut or Copy mode.
The CutCopyMode property can be set to either True or False . On the PC, these have
the same effect (but differ on the Macintosh); namely, to cancel Cut or Copy mode and
remove the moving border that surrounds the region to be cut or copied.
The CutCopyMode property can return False , indicating that Excel is in neither Cut nor
Copy mode, or else one of the two values from the following enum:
xlCopy = 1 ' Copy mode
xlCut = 2 ' Cut mode
DataEntryMode property (R/W Long)
This property returns or sets Data Entry mode. When in Data Entry mode, data can be
entered only in the cells in the currently selected range.
The property can assume any of the following constant values:
Data Entry mode is on.
Data Entry mode is off.
Data Entry mode is on, and pressing Esc will not turn it off.
EditDirectlyInCell property (R/W Boolean)
When this property is True (which is its default value), Excel allows editing in cells.
Otherwise, it does not allow editing in the cells (but you can still edit in the formula bar).
FixedDecimal property (R/W Boolean)
When this property is True , all numeric data entered will be formatted with the number
of fixed decimal places set by the FixedDecimalPlaces property. The default value of this
property is False ; the value of the FixedDecimalPlaces property is ignored.
FixedDecimalPlaces property (R/W Long)
This property returns or sets the number of fixed decimal places used when the
FixedDecimal property is set to True . For example, if the FixedDecimalProperty is True
and FixedDecimalPlaces is set to 3, an entry of 100 in a cell will be displayed as 0.1.