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 |
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 |
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 |
Excel 2007: How to change colors in TextEffect
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 |
All times are GMT +1. The time now is 02:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com