How do I determine when a cell's formatting changes?
 

Is there a way to determine when the user modifies the formatting of a range?
There does not seem to be any event fired when the formatting of a range
changes. Is the only option to programatically scan the cells looking for
changes?

Thanks,

Carl

How do I determine when a cell's formatting changes?
 

All you say is true.

--
Regards,
Tom Ogilvy

"Carl L" wrote in message
...
Is there a way to determine when the user modifies the formatting of a
range?
There does not seem to be any event fired when the formatting of a range
changes. Is the only option to programatically scan the cells looking for
changes?

Thanks,

Carl