Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007: How to change colors in TextEffect
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007: How to change colors in TextEffect
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 2007: How to change colors in TextEffect
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why can I no longer change Font colors in an Excel 2007 Comment? | Excel Discussion (Misc queries) | |||
How do I change/add default colors in Excel 2007? | Excel Discussion (Misc queries) | |||
Using If then to change cell colors in Excel 2007 | Excel Worksheet Functions | |||
excel 2007 colors do not match excel 2003 colors. | Excel Discussion (Misc queries) | |||
How do I change the 10 default text colors in Office 2007 | Excel Discussion (Misc queries) |