ActiveX

To set the background and text colors of locked cells

At run time,

1. If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
2. Specify the background color by setting the LockBackColor property.
3. Specify the text color by setting the LockForeColor property.