I don't think so as that allows you to raise events in your code and trap
these. But the format change would be in Excel, not in your code.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Stefi" wrote in message
...
And can't I define one with Event Statement?

Stefi


"Bob Phillips" ezt írta:

Stefi,

There is no event to trap a format change.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Stefi" wrote in message
...
Hi All,

I'd like to run a macro (similarly to a Change event) when the cell
format
(e.g. font color) of a cell changes.
How can I do that?

Thanks,
Stefi