Colors Property

Applies To

Workbook Object.

Description

Returns or sets an array of colors (from 1 to 56) in the palette for the workbook. Read-write.

See Also

ColorIndex Property.

Example

This example sets the color palette for the active workbook to be the same as the palette for BOOK2.XLS.

ActiveWorkbook.Colors = Workbooks("BOOK2.XLS").Colors