ActiveX
To set the background and text colors of locked cells
At run time,
- If your control contains more than one sheet, specify the sheet with which you want to work by setting the Sheet property.
- Specify the background color by setting the LockBackColor property.
- Specify the text color by setting the LockForeColor property.