Members that Affect the Current State of Excel

The following members have an effect on the current settings of Excel:

CopyObjectsWithCells property (R/WBoolean)

When this property is True, objects (such as embedded controls or shapes) are cut, copied, extracted, and sorted along with cells.

Cursor property (R/W Long)

This property returns or sets the appearance of the mouse pointer. It can be one of the following XlMousePointer constants:

Enum XlMousePointer xlDefault = -4143 xlNorthwestArrow = 1 xlWait = 2 xlIBeam = 3 End Enum

It is considered good programming practice to set the mouse pointer to xlWait if your code will take more than a second or so to complete. Of course, you will need to return the mouse pointer to its previous state when the procedure terminates. The proper way to 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/WLong)

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:

Enum XlCutCopyMode xlCopy = 1 ' Copy mode xlCut = 2 ' Cut mode

End Enum DataEntryMode property (R/WLong)

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:

xlOn

Data Entry mode is on.

xlOff

Data Entry mode is off.

xlStrict

Data Entry mode is on, and pressing Esc will not turn it off.

EditDirectlylnCellproperty (R/WBoolean)

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).

FixedDecimalproperty (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/WLong)

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.

Interactive property (R/WBoolean)

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/WBoolean)

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:

Enum XlDirection xlUp = -4162 xlToRight = -4161 xlToLeft = -4159 xlDown = -4121 End Enum ReferenceStyle property (R/WLong)

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

XlReferenceStyle constants:

Enum XlReferenceStyle xlR1C1 = -4150 xlA1 = 1 End Enum ScreenUpdatingproperty (R/WBoolean)

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.

SheetsInNewWorkbookproperty (R/WLong)

This property returns or sets the number of sheets that Excel automatically inserts into new workbooks.

ShowChartTipNames property (R/WBoolean)

When this property is True, its default value, Excel charts show chart tip names.

ShowChartTipValuesproperty (R/WBoolean)

When this property is True, its default value, Excel charts show chart tip values. ShowToolTips property (R/WBoolean)

When this property is True, its default value, ToolTips are turned on.

StandardFontproperty (R/W String)

This property returns or sets the name of the standard font. Note that the change does not take effect until Excel is restarted.

StandardFontSize property (R/WLong)

This property returns or sets the standard font size, in points. The change does not take effect until Excel is restarted.

StartupPath property (Read-Only String)

This property returns the complete path of the startup folder, excluding the final separator.

TemplatesPath property (Read-Only String)

This property returns the path where templates are stored.

0 0

Post a comment