No events when changing the color of a cell

[Robert kempers]

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

 

[Frank Kabel]

Hi Robert
AFAIK no chance to create such an event

 

[Mike Fogleman]

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

 

[Bob Phillips]

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)

 

[Robert Kempers]

Thanks for the information



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