Hej Nigel,

Unfortunately this feature is turned off in excel 2007: I cannot record any
behaviour of shapes anymore.


"Nigel" wrote:

Your easiest option is to turn on the macro recorder, make the change
manually, then turn off recorder. Inspect code using the VB editor. Alt-F11

--

Regards,
Nigel




"Henrik" wrote in message
...
Hej All,

I've inserted a texteffecc in a worksheet and need to change the "fill"
and
"line" color of it. What's the code to do this?

TIA,
Henrik