View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default Excel 2007: How to change colors in TextEffect

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