Expand Minimize
This topic has not yet been rated - Rate this topic

Color Cell (Layers Section)

Published: July 16, 2012

Specifies the color used to display the layer.

To set the color, enter a number from 0 to 23.

This cell value corresponds to the Layer color setting in the Layer Properties dialog box (in the Editing group on the Home tab, click Layers and then click Layer Properties).

To enter a custom color, use the RGB or HSL function. The value of a custom color is its RGB color, and RGB(r, g, b), rather than a number, will be shown in the ShapeSheet window. When used in numeric operations, custom colors have values of 24 and above. A value of 255 indicates that the layer has no color.

You can set the transparency of the layer color in the Transparency cell.

To get a reference to the Color cell by name from another formula, or from a program using the CellsU property, use:

Cell name:

Layers.Color[i]
where i = <1>, 2, 3, ...

To get a reference to the Color cell by index from a program, use the CellsSRC property with the following arguments:

Section index:

visSectionLayer

Row index:

visRowLayer + i
where i = 0, 1, 2, ...

Cell index:

visLayerColor

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.