| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting ThemeFont and ThemeColor
Hello...
Dim sh As Shape Set sh = Sheet1.Shapes.AddShape(msoShapeRectangle, 0, 0, 100, 100) sh.TextFrame2.TextRange.Text = "Hello world!" sh.TextFrame.Characters(0, 12).Font.ThemeFont = xlThemeFontMajor sh.TextFrame.Characters(0, 12).Font.ThemeColor = xlThemeColorLight2 both last two rows returns 1004 Application-defined or object-defined error. Anybody has an idea what is wrong? Thanks! Jan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How I can get color (RGB value) from .ThemeColor + .TintAndShade? | Excel Programming | |||
| themecolor, colorindex, color picker | Excel Programming | |||
| Excel 2007, ThemeColor Light and Dark reversed | Excel Programming | |||
| Setting default pivot table field setting to "sum" | Excel Discussion (Misc queries) | |||
| VBA Setting .Value to a date does not respect local system setting | Excel Programming | |||
Threaded Mode
