hi,

no, because problem is that adding or suppressing comments doesn't cause any events,
so there's isn't exist way to detect this changes.


--
isabelle

Le 2011-04-29 22:10, Colin Hayes a écrit :
In article , isabelle writes
hi,

sorry Colin, forget the formula, it's a bad idea, because there's no recalculation
even adding Application.Volatile
but you can execute the macro



Hi Isabelle

OK Thank you.

Could an extra line be added to the macro to return the cells to white if the comment is deleted?

Thanks again.