a way to trigger event when cell color changes
Posted on 2009-12-20
I'm using Excel 2007,
I terribly need a way to trigger a vba routine anytime a user simply changes a cell color.
neither the Workbook_SheetChange OR the Worksheet_Change events triggers when a color changes.
Is there any other working way? i don't care if the trigger is something much more general, like "each time the left mouse button is pressed", as long as it will recognize pressing the color button, etc..
thank you very very much