I am programming with VBA Excel 2000. I find out that the sub
Worksheet_Change() is not activated when you change the color of a
cell. Does somebody knows another way to generate an event when the
color of a cell is changed.

Kind regards

Hi Robert
AFAIK no chance to create such an event

-----Original Message-----
I am programming with VBA Excel 2000. I find out that the
sub
Worksheet_Change() is not activated when you change the
color of a
cell. Does somebody knows another way to generate an
event when the
color of a cell is changed.

Kind regards
.

Thanks for the information



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

This is not a simple task, but read Chip Pearson's site on checking for
cells color properties:
http://www.cpearson.com/excel/CFColors.htm

Mike F
"Robert kempers" wrote in message
om...
I am programming with VBA Excel 2000. I find out that the sub
Worksheet_Change() is not activated when you change the color of a
cell. Does somebody knows another way to generate an event when the
color of a cell is changed.

Kind regards

It's not only not simple, it's not possible.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Mike Fogleman" wrote in message
news:XqLlc.19721$Ia6.2918393@attbi_s03...
This is not a simple task, but read Chip Pearson's site on checking for
cells color properties:
http://www.cpearson.com/excel/CFColors.htm

Mike F
"Robert kempers" wrote in message
om...
I am programming with VBA Excel 2000. I find out that the sub
Worksheet_Change() is not activated when you change the color of a
cell. Does somebody knows another way to generate an event when the
color of a cell is changed.

Kind regards