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