Hej Nigel,

It is the feature being disabled for certain things, of which formatting
shapes is one.
So I can record lots of stuff as long as I do not work with shapes...
It works in excel 2003, but not in 2007. And in 2007 certain aspects of the
shapes have been changed, so I cannot use recorded 2003-code either.


Regards,
Hendrik.

"Nigel" wrote:

Is it that the developer tab is not showing in the ribbon or has the feature
been disabled?

Check the option Excel-Options- ShowDeveloperTab in the Ribbon

or run this code.....

Application.ShowDevTools = True


--

Regards,
Nigel




"Henrik" wrote in message
...
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