Spread 8.0 Documentation
LockBackColor Property
Support Options
ActiveX Reference > ActiveX Properties > LockBackColor Property

Glossary Item Box

LockBackColor Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the background color of locked cells. This property is available at run time only.

Syntax

C++

unsigned long CSpreadSheet::GetLockBackColor( );
void CSpreadSheet::SetLockBackColor(unsigned long value);

Visual Basic

[form.]fpSpread.LockBackColor[ = color]

Remarks

The default value for the LockBackColor property is SPREAD_COLOR_NONE. When the LockBackColor property is set to this value, the current cell background color set by the BackColor property is used for the locked cells.

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property.

This property does not have an effect unless one or more cells are marked as locked (their Lock property is set to True) and the Protect property is set to True.

Set the text color for locked cells using the LockForeColor property.

Spread Designer

Choose the Sheet menu, then the Sheet Colors menu, select the Sheet Colors tab, and then choose LockBackColor from the Property drop-down list box in the Sheet Settings dialog box.

Data Type

Color

See Also

Setting Background and Text Colors for Locked Cells

BackColor, Lock, LockForeColor, Protect, Sheet properties

DLL Correspondence

SSGetLockColor, SSSetLockColor functions

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.